quenine2024-03-17 09:57 AM copy
Updated 2024-04-18
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
-- 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