CASE when POSITION > '7' then 'big' else 'small' end as type,

count(*) as txs

FROM blast.core.fact_transactions

WHERE date(block_timestamp) > '{{ date }}'

AND type LIKE '{{ tx_type }}'

GROUP BY 1