/lab-sql-self-cross-join

logo_ironhack_blue 7

Lab | SQL Self and cross join

In this lab, you will be using the Sakila database of movie rentals.

Instructions

  1. Get all pairs of actors that worked together.
  2. Get all pairs of customers that have rented the same film more than 3 times.
  3. Get all possible pairs of actors and films.