I want to get from this table, 2 columns, event_name and category name.
I want to know the columns where there is one worker record for 'program_leader', but there is no similar record (event_name and category_name) for 'program_admin'
select category_name, event_name from security_events_view where
category_name not in('ABA Data Collection', 'ABA Session', 'MST Events'
) and worker_role = 'Program_Leader'
order by category_name
category_name event_name Worker_role
Home Hair_Brushing Program_leader
Home Hair_Brushing Program_admin
Home Teeth_Brushing Program_leader
With this input, we want to see Home Teeth_Brushing
as the result set. Since there is no row for worker_role = Program _admin