SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
select * from film limit 5; SELECT a.actor_id, CONCAT(a.first_name, ' ', a.last_name) AS actor_name, AVG(f.rental_rate) AS avg_film_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 GROUP BY a.actor_id, actor_name ORDER BY avg_film_rating DESC LIMIT 7;

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear