SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
SELECT JSON_ARRAYADD('', category.name, '', COUNT(film_category.film_id)) AS films_by_category FROM film_category JOIN category ON film_category.category_id=category.category_id GROUP BY film_category.category_id

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear