Case when to update table

PHOTO EMBED

Tue Mar 15 2022 06:32:01 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

update train_employeedatabase_csv 
set yeargroup = case when age < 18 then 'Under 18'
when age between 18 and 24 then 'On 18-24'
when age between 25 and 34 then 'On 25-34'
when age > 34 then 'Over34'
end 
content_copyCOPY