HI I am not sure how to code this. I want that for some of the event_names to classify them as 'minor' or major restriction. If these 2 are the value then 'minor' else 'major'. I would like there to be a new column showing this.
select cv.first_name, cv.last_name, ev.approved_date, ev.event_name, ev.staff_desc from all_clients_view cv
join event_view ev
on cv.people_id = ev.people_id
if ev.event_name in ('Restrictions Minor', 'RTF Placement') then 'Minor' else 'Major'
where ev.category_name = 'Restrictions/Alerts'