SQLize | PHPize | SQLtest

-- SELECT c.name AS category, -- select CASE WHEN store_id = 1 THEN COUNT(store_id) END AS store_1, -- CASE WHEN store_id = 2 THEN COUNT(store_id) END AS store_2 SELECT c.name AS category, (SELECT COUNT(store_id) FROM film f LEFT JOIN film_category fc ON f.film_id = fc.film_id LEFT JOIN category c ON fc.category_id = c.category_id LEFT JOIN inventory i ON f.film_id = i.film_id WHERE store_id = 1) FROM film f LEFT JOIN film_category fc ON f.film_id = fc.film_id LEFT JOIN category c ON fc.category_id = c.category_id LEFT JOIN inventory i ON f.film_id = i.film_id GROUP BY category, -- SELECT store_id, -- CASE WHEN store_id = 1 THEN COUNT(store_id) END AS store_1, -- CASE WHEN store_id = 2 THEN COUNT(store_id) END AS store_2 -- FROM film f LEFT JOIN inventory i ON f.film_id = i.film_id -- GROUP BY store_id