Amazon interview question

SQL scenarios, Partitioning, Indexes