-- forked from kellen / % of Tx With Additional Fee @ https://flipsidecrypto.xyz/kellen/q/EwUNKi45luuU/of-tx-with-additional-fee
SELECT DATE_TRUNC('week', block_timestamp)::date AS date
, ROUND(100 * AVG(CASE WHEN fee - (ARRAY_SIZE(signers) * 5000) > 0 THEN 1 ELSE 0 END), 2) AS pct_with_additional_fee
FROM solana.core.fact_transactions
WHERE date >= '2022-06-01'
AND succeeded
GROUP BY 1
ORDER BY 1 DESC