SQLAI.ai

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