Query editor
WITH totals AS (SELECT count(*) as total_programsFROM dune.solana_team.dataset_programinfo)SELECT'Has IDL' as idl_status,COUNT(*) as count,ROUND(CAST(COUNT(*) AS DOUBLE) / CAST(t.total_programs AS DOUBLE), 4) as ratio,ROUND(100.0 * CAST(COUNT(*) AS DOUBLE) / CAST(t.total_programs AS DOUBLE), 2) as percentageFROM dune.solana_team.dataset_programinfoCROSS JOIN totals tWHERE has_idl = trueGROUP BY t.total_programsUNION ALLSELECT'No IDL' as idl_status,COUNT(*) as count,ROUND(CAST(COUNT(*) AS DOUBLE) / CAST(t.total_programs AS DOUBLE), 4) as ratio,ROUND(100.0 * CAST(COUNT(*) AS DOUBLE) / CAST(t.total_programs AS DOUBLE), 2) as percentageFROM dune.solana_team.dataset_programinfoCROSS JOIN totals tWHERE has_idl = false OR has_idl IS NULLGROUP BY t.total_programsORDER BY count DESC;