Cenduit interview question

joins and basic SQL constraints