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
INNERJOIN film_actor fa ON a.actor_id = fa.actor_id
INNERJOIN film f ON fa.film_id = f.film_id
WHERE
a.first_name LIKE'A%';