Amazon interview question

Live Coding (SQL)! Join and Where Clause