Amazon Interview Question

SQL scenarios, Partitioning, Indexes