Skip to content

Instantly share code, notes, and snippets.

@Shaddyjr

Shaddyjr/coding_challenge_2e.sql

Created July 17, 2019 05:34
Show Gist options
  • Save Shaddyjr/89c7428d741daaec5315009819b639b2 to your computer and use it in GitHub Desktop.
Save Shaddyjr/89c7428d741daaec5315009819b639b2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
coding_challenge_2e.sql
SELECT
p1.actor_id act1,p2.actor_id act2, p2.film_id
FROM film_actor p1
JOIN film_actor p2
ON p1.film_id = p2.film_id
AND p1.actor_id < p2.actor_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment