CommencerCommencer gratuitement

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.

Cet exercice fait partie du cours

Introduction to Oracle SQL

Afficher le cours

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

-- Select first and last names
SELECT ___ || ' ' || ___ AS "Employee",
       ___ || ' ' || ___ AS "Customer"
-- Join Employee with Customer
FROM ___ e ___ ___ ___ c
Modifier et exécuter le code