Crossover for Work interview question

Missing patterns, LEFT JOINS in sql, javascript