Speridian Technologies interview question

Write a SQL query to retrieve data.