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.
Diese Übung ist Teil des Kurses
Introduction to Oracle SQL
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
-- Select city in one column, first and last name in another
SELECT ___
___ || ' ' || ___ customer_1
-- Alias Customer table as c1
FROM Customer ___