Pregunta de entrevista de Clipboard

I was asked to write SQL querier for 10 different scenarios using a defined data schema.