Pergunta de entrevista da empresa Amazon

Just some basic SQL questions. Group, Join