SELECT

DISTINCT(SIGNERS[0]) AS WALLET,SUM(FEE)/1000000000 AS FEE

FROM solana.core.fact_transactions

WHERE BLOCK_TIMESTAMP >'2022-01-01'

AND SUCCEEDED='FALSE'

GROUP BY 1

ORDER BY 2 DESC

LIMIT 5),

PROGRAM AS (

SELECT DISTINCT(PROGRAM_ID) AS PRGRAM ,SUM(FEE)/1000000000 AS FEE,LABEL

FROM solana.core.fact_events E

INNER JOIN solana.core.fact_transactions T ON T.TX_ID=E.TX_ID

INNER JOIN solana.core.dim_labels L ON L.ADDRESS=E.PROGRAM_ID

WHERE E.BLOCK_TIMESTAMP >'2022-06-01'

AND E.SUCCEEDED='FALSE'

GROUP BY 1,3

ORDER BY 2 desc

LIMIT 5

SELECT *

FROM PROGRAM