Query editor
WITHtt AS (SELECT"_borrower","_debt","evt_block_number","evt_index"FROMliquity_ethereum.BorrowerOperations_evt_TroveUpdatedUNION ALLSELECT"_borrower","_debt","evt_block_number","evt_index"FROMliquity_ethereum.TroveManager_evt_TroveUpdated),t AS (SELECT"_borrower","_debt",ROW_NUMBER() OVER (PARTITION BY"_borrower"ORDER BY"evt_block_number" DESC,"evt_index" DESC) AS "updateNumber"FROMtt),b AS (SELECT"_borrower" AS "user","_debt" / CAST(1e18 AS DOUBLE) AS "debt"FROMtWHERE"updateNumber" = 1AND "_debt" > 0ORDER BY1),dd AS (SELECT"_depositor","_newDeposit",ROW_NUMBER() OVER (PARTITION BY"_depositor"ORDER BY"evt_block_number" DESC,"evt_index" DESC) AS "updateNumber"FROMliquity_ethereum.StabilityPool_evt_UserDepositChanged),d AS (SELECT