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

Exercise

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.

Instructions 1/3

undefined XP
    1
    2
    3
  • Select the city in a first column, as well as the customer's first and last name grouped in a second column called "customer_1". Alias the customer table as c1.