IBM Interview Question

SQL joins, coding in R