SELECT

DISTINCT TX_ID AS Minting_txns

FROM solana.fact_events

WHERE PROGRAM_ID='tovt1VkTE2T4caWoeFP6a2xSFoew5mNpd7FWidyyMuk'

AND INDEX=4

AND INSTRUCTION:accounts[1]::string='rLmyBAjCYR1MNc3KSG77y5XXT2DuMxkcxfqLYvjjJCs'

AND INSTRUCTION:accounts[12]::string='Lednq4o7qpgBPVpr69ECzUqwZwXPevBdm4iXUxrLeiL'),

MNDE_transferred AS (

SELECT

INSTRUCTION:parsed:info:authority::string AS Minter,

SUM(INSTRUCTION:parsed:info:amount::INT)/1E9 AS MNDE_TRANSFERRED

FROM solana.fact_events A INNER JOIN mint B ON A.TX_ID=B.Minting_txns

WHERE INDEX=1

AND EVENT_TYPE='transfer'

GROUP BY 1

ORDER BY 2 DESC)

CASE

WHEN MNDE_TRANSFERRED < 5000 AND MNDE_TRANSFERRED >= 1000 THEN 'Chef#1'

WHEN MNDE_TRANSFERRED < 25000 AND MNDE_TRANSFERRED >= 5000 THEN 'Chef#2'

WHEN MNDE_TRANSFERRED < 100000 AND MNDE_TRANSFERRED >= 25000 THEN 'Chef#3'

WHEN MNDE_TRANSFERRED < 250000 AND MNDE_TRANSFERRED >= 100000 THEN 'Chef#4'

WHEN MNDE_TRANSFERRED >= 250000 THEN 'Chef#5'

END AS Chefs,

COUNT(Chefs) AS Number_of_chefs

FROM MNDE_transferred

GROUP BY 1

ORDER BY 2 DESC