Skip to content

Latest commit

 

History

History
11 lines (7 loc) · 464 Bytes

Lab SQL Self and cross join.md

File metadata and controls

11 lines (7 loc) · 464 Bytes

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.