DXC Technology Interview Question

Can you do this query in SQL?