MySQL - 참조 - 함수 - AVG()

AVG()

AVG() 함수는 식의 평균 값을 반환한다.

⭐ Null 값은 무시된다.

MySQL 4.0부터 작동한다.

AVG(expression)

매개변수

expression

숫자 값.

SELECT AVG(Price) AS AveragePrice FROM Products;

기본 예시

AveragePrice
28.866364

SELECT * FROM Products
WHERE Price > (SELECT AVG(Price) FROM Products);

기본 예시

ProductID	ProductName	SupplierID	CategoryID	Unit	Price
7	Uncle Bob’s Organic Dried Pears	3	7	12 – 1 lb pkgs.	30.00
8	Northwoods Cranberry Sauce	3	2	12 – 12 oz jars	40.00
9	Mishi Kobe Niku	4	6	18 – 500 g pkgs.	97.00
10	Ikura	4	8	12 – 200 ml jars	31.00
12	Queso Manchego La Pastora	5	4	10 – 500 g pkgs.	38.00
17	Alice Mutton	7	6	20 – 1 kg tins	39.00
18	Carnarvon Tigers	7	8	16 kg pkg.	62.50
20	Sir Rodney’s Marmalade	8	3	30 gift boxes	81.00
26	Gumbär Gummibärchen	11	3	100 – 250 g bags	31.23
27	Schoggi Schokolade	11	3	100 – 100 g pieces	43.90
28	Rössle Sauerkraut	12	7	25 – 825 g cans	45.60
29	Thüringer Rostbratwurst	12	6	50 bags x 30 sausgs.	123.79
32	Mascarpone Fabioli	14	4	24 – 200 g pkgs.	32.00
38	Côte de Blaye	18	1	12 – 75 cl bottles	263.50
43	Ipoh Coffee	20	1	16 – 500 g tins	46.00
51	Manjimup Dried Apples	24	7	50 – 300 g pkgs.	53.00
53	Perth Pasties	24	6	48 pieces	32.80
56	Gnocchi di nonna Alice	26	5	24 – 250 g pkgs.	38.00
59	Raclette Courdavault	28	4	5 kg pkg.	55.00
60	Camembert Pierrot	28	4	15 – 300 g rounds	34.00
62	Tarte au sucre	29	3	48 pies	49.30
63	Vegie-spread	7	2	15 – 625 g jars	43.90
64	Wimmers gute Semmelknödel	12	5	20 bags x 4 pieces	33.25
69	Gudbrandsdalsost	15	4	10 kg pkg.	36.00
72	Mozzarella di Giovanni	14	4	24 – 200 g pkgs.	34.80

W3C School - MySQL AVG() Function

W3C School - SQL Tutorial

Mingg`s Diary

밍구

공부 목적 블로그