Code to report wynton usage by year

select  sge_project,
        sge_owner, 
        sge_qname, 
        sge_granted_pe, 
        sge_slots, 
        round(sum ( gen_slot_hours)) as sum_slot_hours, 
        round(avg(gen_cpu_time_div_wallclock)::numeric,2) as avg_threadiness,
        count(*) 
from accounting 
where   gen_end_time >= '2024-01-01'
        and gen_end_time <= '2024-12-31'  
        and sge_qname not like '%gpu%' 
group by 1,2,3,4,5  
order by count desc ;