Pregunta de entrevista de Amazon

In 10mins, write four SQL based solutions using a small dataset given.