BETA
Session Ready
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.