Fresche Solutions interview question

Q: SQL query. (Join, Group by, Order by)