CommencerCommencer gratuitement

Self joins

People who love music also love to discuss it or discover new artists. eSymphony is thinking about organizing a meetup to gather customers from a same city. That's not all: they would like to organize a speed meeting session, so that all customers get to speak with each other and exchange at least one artist.

They tasked you with coming up with a list of customer matches per city.

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 city in one column, first and last name in another
SELECT ___
       ___ || ' ' || ___ customer_1
-- Alias Customer table as c1
FROM Customer ___
Modifier et exécuter le code