Amazon interview question

Database tuning / SQL / Design tables for a scenario