Eccella interview question

Write an SQL statement to retrieve some info