Pergunta de entrevista da empresa Tulip

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