Thanks Joe. That gave me error Status not found. This one worked.
with maxstat as (
select count(gs1), max(status) from table
where ts between '2019-12-30' and '2020-01-02'
group by status)
select * from maxstat
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.