Using SQL in PhpmyAdmin from the Sakila database

1. Write a query that finds, for each customer X, another customer Y who has rented at least one movie in common with X. Find all such pairs of Customers (X, Y) and against each pair, the number of overlapping movies. Order the results by the number of overlapping movies in descending order. (update Feb 8) The query should thus have these columns: customer X first_name, customer X last_name, customer Y first_name, customer Y last_name, nOfOverlabMovies