빅데이터전문 빅데이터전문

USE sakila; -- 1. SELECT category_id, name FROM category WHERE name IN ('Comedy', 'Sports', 'Family'); -- 2. SELECT film_id, category_id FROM film_category WHERE film_id = 2; -- 3. SELECT category_id, COUNT(category_id) FROM film_category GROUP BY category_id; -- 4. -- join SELECT name, COUNT(*) AS film_count FROM category JOIN film_category ON film_category.category_id = category.category_id WH..