Pregunta de entrevista de Media.net

SQL questions and functions almost 45 mins in the first round.