Amazon interview question

Sql coding cases. What data are needed for the case