집계함수 연습

집계 함수 테스트 CREATE TABLE pky902 (id INTERGER PRIMARY KEY, name TXT, quantity INTERGER, aisle INTERGER); INSERT INTO pky902 VALUES (1, "JDNY", 2, 1); INSERT INTO pky902 VALUES (2, "21C", 1, 3); INSERT INTO pky902 VALUES (3, "COSMOS", 1, 3); INSERT INTO pky902 VALUES (4, "JCCOPY", 4, 2); SELECT SUM(quantity) FROM pky902; SELECT aisle, SUM(quantity) FROM pky902 group by aisle; SELECT aisle, MAX(quant..

원문링크 : 집계함수 연습