KAYAK interview question

SQL questions: how to deal with duplicates, differences between JOINs