get all actors starting with A and films with title, release year, length and rating
SELECT a.first_name, a.last_name, f.title, f.release_year, f.length, f.rating
FROM actor a
INNER JOIN film_actor fa ON a.actor_id = fa.actor_id
INNER JOIN film f ON fa.film_id = f.film_id
WHERE a.first_name LIKE 'A%';
- Public
- ·
- Thu, 02 Mar 2023 14:25:10 GMT