Tulip interview question

Simple SQL queries where we have to use Aggregate functions and Join to solve it.