deborasitanggang

--------------------------------------------------------------------------------
--Daily pusdafil status by name distribution in the last 30 days.
select
	to_char(cdate, 'yyyy-mm-dd') as day_of_pusdafil,
	status,
	count(1) as total_pusdafil
from ops.pusdafil_upload
where cdate::date > current_date - interval '30' day
group by 1,2
order by 1 desc