IBM interview question

Some moderate SQL query questions utilizing Group BY and Joins