date_trunc('day', block_timestamp) as time,

COUNT(CASE WHEN event_type = 'delegate' THEN 'Staking' END) AS "Staking",

COUNT(CASE WHEN event_type <> 'delegate' THEN 'Other' END) AS "Other",

100*"Staking"/"Other" as Persentage

FROM solana.events

WHERE block_timestamp > '2022-01-01' and block_timestamp < '2022-02-10'

GROUP BY 1