select * from (select ve.event_date, vc.prim_key from vol_att va inner join vol_evn ve on va.event_fkey = ve.prim_key left join vol_con vc on va.contact_fkey = vc.prim_key where va.attendance_type is not null ) pivot ( count(distinct prim_key) for event_date in ( to_date('2023-03-30', 'yyyy-mm-dd') Mar_30_2023, to_date('2023-04-18', 'yyyy-mm-dd') Apr_18_2023 ) );