Eccella Interview Question

Write an SQL statement to retrieve some info