[SQL] 데이터 집계(SUM,MAX,MIN 등, GROUP BY)
https://ko.khanacademy.org/computing/computer-programming/sql/sql-basics/pt/aggregating-data 집계함수의 사용 CREATE TABLE groceries (id INTEGER PRIMARY KEY, name TEXT, quantity INTEGER, aisle INTEGER); INSERT INTO groceries VALUES (1, "Bananas", 4, 7); INSERT INTO groceries VALUES(2, "Peanut Butter", 1, 2); INSERT INTO groceries VALUES(3, "Dark Chocolate Bars", 2, 2); INSERT INTO groceries VALUES(4, "I..
프로그래밍 공부/데이터베이스 & SQL
2024. 2. 20. 11:51