KAYAK Interview Question

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