Crossover for Work Interview Question

Missing patterns, LEFT JOINS in sql, javascript