1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Oracle SQL

Exercise

Cross joins

For a business to be successful, it's important to treat your most loyal customers well. You'd like to make sure that the support team is aware of who these customers are, so that they can prioritize their requests. You'd like to create a table where each of the support agents gets matched to each customer that spent at least $45 with eSymphony.

Instructions 1/4

undefined XP
    1
    2
    3
    4
  • Select the first name and the last name of the employees and customers, and cross join the customer table with the employee table, alias the customer table as c and the employee table as e.