Session Ready
Exercise

Performing an anti-join

In our music streaming company dataset, each customer is assigned an employee representative to assist them. In this exercise, filter the employee table by a table of top customers, returning only those employees who are not assigned to a customer. The results should resemble the results of an anti-join. The company's leadership will assign these employees additional training so that they can work with high valued customers.

The top_cust and employees tables have been provided for you.

Instructions 1/3
undefined XP
  • 1
  • 2
  • 3
  • Merge employees and top_cust with a left join, setting indicator argument to True. Save the result to empl_cust.