AVG Syntax:
SELECT AVG(column_name) FROM table_name
Sales table:
| ID | PRICE | NAME |
|---|---|---|
| 1 | 200 | A |
| 2 | 500 | B |
| 3 | 900 | C |
| 4 | 500 | D |
AVG Example:
SELECT AVG(price) FROM store;
AVG Result:
525
SELECT AVG(column_name) FROM table_name
| ID | PRICE | NAME |
|---|---|---|
| 1 | 200 | A |
| 2 | 500 | B |
| 3 | 900 | C |
| 4 | 500 | D |
SELECT AVG(price) FROM store;
525