Easy SQL Challenge: Joining 3 Tables

365 Days of Daily Coding: Day 44

It has been a historic week with the massive surge in the share price of GME (Gamestop). This week will be remembered for years to come. For one, I am with the movement. On the other hand, I fear for those people that might have hopped in the trend without knowing what they are getting themselves into and investing their entire hard earned savings dreaming of millions. Its a game of winners and losers. There is a possibility of losing more since the game is rigged. It was never fair to begin with. I am excited to see what unfolds of this madness.

Today, I was caught up with work so I only solved one easy challenge. I was co-hosting a team building session with a colleague. I did not feel productive as I felt drained the entire day cause I did not have a quality sleep.

Easy Challenge 1:

SELECT a.first_name, a.last_name
FROM actor a INNER JOIN film_actor f
ON a.actor_id = f.actor_id
INNER JOIN film m
ON f.film_id = m.film_id
WHERE UPPER(m.title) = 'AFRICAN EGG';

Leave a comment