Compare rows within one table · exercise 1 of 1 · free preview
Give the table two aliases, like a and b, and join them on a shared column. a.customer_id < b.customer_id keeps each pair once.
List every pair of different customers who live in the same city. Show both last names.
Tables in this practice shop
customersproductsordersorder_items