Untitled

select order_status as hoso_order_status, count(1) from tibom.tom_order tom WHERE DATE(updated_on) >= '2023-04-06' AND DATE(updated_on) <= '2023-10-03' GROUP BY hoso_order_status date_trunc('day', CAST(hoso_updated_on ));