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

-- 26. DROP VIEW top5_genres; -- 27. SELECT * FROM rental; -- rental_date, inventory_id SELECT * FROM inventory; -- inventory_id >> film_id SELECT * FROM film; -- film_id, title SELECT f.title, COUNT(*) FROM rental r JOIN inventory i ON r.inventory_id = i.inventory_id JOIN film f ON i.film_id = f.film_id GROUP BY 1 ORDER BY 2 DESC LIMIT 3; -- 28. SELECT * FROM rental; SELECT * FROM inventory; SE..

-- 21. SELECT * FROM film; -- film_id 17:ALONE TRIP SELECT actor_id FROM film_actor WHERE film_id = 17; SELECT CONCAT(first_name, ' ', last_name) AS 'actor_name' FROM actor WHERE actor_id IN (SELECT film_actor.actor_id FROM film_actor WHERE film_id = (SELECT film.film_id FROM film WHERE title = 'ALONE TRIP')); -- 22. SELECT CONCAT(first_name, ' ', last_name) AS 'Staff Member', SUM(amount) AS 'To..

-- 16. SELECT * FROM payment; -- payment_id >> customer_id SELECT * FROM customer; -- customer_id >> store_id SELECT * FROM store; -- store_id >> address_id SELECT * FROM address; -- address_id >> city_id SELECT * FROM city; -- city_id >> country_id SELECT CONCAT(city, ',', country) store, s.store_id AS "Store ID", SUM(amount) AS "Total Sales" FROM payment p JOIN customer cu ON p.customer_id = c..

-- 11. SELECT COUNT(*) FROM film_category WHERE category_id = (SELECT category_id FROM category WHERE name = 'Comedy'); -- 12. SELECT COUNT(*) FROM customer RIGHT JOIN address ON customer.address_id = address.address_id WHERE customer.address_id IS NULL; -- 13. SELECT CONCAT(c.first_name, ' ', c.last_name), c.email FROM customer c JOIN address a ON c.address_id = a.address_id JOIN city ci ON a.c..

-- 6. SELECT name, COUNT(*) AS film_count FROM category JOIN film_category ON film_category.category_id = category.category_id GROUP BY category.category_id HAVING film_count >= 70; -- 7. SELECT name, COUNT(*) FROM (SELECT film_category.film_id, category_id FROM (SELECT film_id FROM rental JOIN inventory ON rental.inventory_id = inventory.inventory_id) AS a JOIN film_category ON a.film_id = film..

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..

# while 반복문을 활용한 숫자 추측 게임 import random as rd # 1에서 100 사이의 정수를 무작위로 선택 rand_num = rd.randint(1, 100) # 사용자에게 숫자를 맞추는 게임 시작 print("up and down game!") print("target number 보다 작은 숫자를 입력하면 up! 출력") print("target number 보다 큰 숫자를 입력하면 down! 출력") user_num = -99 # 사용자가 정답을 맞출 때까지 반복 while rand_num != user_num: # 사용자에게 숫자 입력 받기 user_num = int(input("1 ~ 100 사이의 숫자를 입력하세요: ")) # 입력한 숫자에 대한 피드백 제공 if use..

# 테스트용 데이터 test_students = [ {'name': 'Alice', 'grades': [80, 90, 75]}, {'name': 'Bob', 'grades': [92, 88, 94]}, {'name': 'Charlie', 'grades': [85, 78, 92]}, {'name': 'David', 'grades': [95, 89, 88]}, ] # 최댓값 담을 변수 max_score = 0 # 과목별 성적 누계 리스트 scores = [0] * 3 # 평균 성적 계산 print(test_students) name_list = [] for key, student in enumerate(test_students): # 평균 구해서, key average로 추가해서 넣기 student_scor..