date_trunc('d', block_timestamp) as _date,

case

when gas_used > attached_gas then 'more'

when gas_used < attached_gas then 'less'

when gas_used = attached_gas then 'same'

else 'ERROR'

end as gas_usage,

count(distinct tx_hash) as txs

from near.core.fact_transactions

group by 1,2

order by 1,3;