quenine2024-03-17 09:57 AM copy
    Updated 2024-04-18
    -- forked from mustafaotaru / 2024-03-17 09:57 AM @ https://flipsidecrypto.xyz/mustafaotaru/q/dYgLQ4JOGGvd/2024-03-17-09-57-am

    SELECT
    count(fact_transactions_id) AS transactions,
    status,
    ROUND((count(fact_transactions_id) / (SELECT count(fact_transactions_id) FROM blast.core.fact_transactions)) * 100, 2) AS percentage
    FROM blast.core.fact_transactions
    GROUP BY status
    ORDER BY count(fact_transactions_id) DESC
    LIMIT 100;


    QueryRunArchived: QueryRun has been archived