Amazon interview question

Write SQL statements pertaining to joins