Pregunta de entrevista de Orange

A programming problem, a SQL problem, and software related questions.