DXC Technology interview question

Can you do this query in SQL?