ROITI interview question

Write an SQL query to obtain x,y,z.