XYZ interview question

Write an SQL query categorising people in a data set