with tbl1 as (select count(price_usd) as less_than_50
from terra.oracle_prices where SYMBOL='LUNA' and BLOCK_TIMESTAMP:: date >= '2021-10-01' and BLOCK_TIMESTAMP:: date < '2021-11-01' and HOUR(BLOCK_TIMESTAMP)=0
and price_usd <50)
, tbl2 as (select count(price_usd) as greater_than_50
from terra.oracle_prices where SYMBOL='LUNA' and BLOCK_TIMESTAMP:: date >= '2021-10-01' and BLOCK_TIMESTAMP:: date < '2021-11-01' and HOUR(BLOCK_TIMESTAMP)=0
and price_usd >=50)
select * from tbl1,tbl2