SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
SELECT name as category, AVG(length) as avg_length FROM category as c JOIN film_category as fc ON c.category_id = fc.category_id JOIN film as f ON f.film_id = fc.film_id GROUP BY category HAVING avg_length > 120 ORDER BY avg_length DESC

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear