Amazon interview question

SQL Select, Insert and update with joins and where clauses