Pregunta de entrevista de Amazon

Sql coding cases. What data are needed for the case