Query editor
WITHtt AS (SELECT_borrower,_coll / 1e18 AS coll,evt_block_number,evt_indexFROMliquity_ethereum.BorrowerOperations_evt_TroveUpdatedUNION ALLSELECT_borrower,_coll / 1e18 AS coll,evt_block_number,evt_indexFROMliquity_ethereum.TroveManager_evt_TroveUpdated),t AS (SELECTCASEWHEN coll = 0 THEN NULLWHEN coll <= 10 THEN '0-10'WHEN coll <= 100 THEN '10-100'WHEN coll <= 1000 THEN '100-1K'WHEN coll <= 10000 THEN '1K-10K'WHEN coll <= 100000 THEN '10K-100K'ELSE '🐳'END AS collateral,ROW_NUMBER() OVER (PARTITION BY_borrowerORDER BYevt_block_number DESC,evt_index DESC) AS updateNumberFROMtt)SELECTcollateral,COUNT(*) AS trovesFROMtWHERENOT collateral IS NULLAND updateNumber = 1GROUP BY1ORDER BY2 DESC/* v1 codewith tt as (select "_borrower", "_coll" / 1e18 as "coll", "evt_block_number", "evt_index"from liquity."BorrowerOperations_evt_TroveUpdated"union allselect "_borrower", "_coll" / 1e18 as "coll", "evt_block_number", "evt_index"