SQL (8) AVG

SQL avg Syntax
SELECT AVG (column_name) from table_name
New table:
StudentS

s_id Grade Name Phone
1 98 Xiao Ming 123456
2 97 small Yellow 232456
3 95 Small Mile 987654
4 93 Little 654321
5 90 Pico 321065

Inquire:
SELECT AVG (Grade) as Gradeaverage from StudentS

Results:
Gradeaverage
94

We want to find the names of students with Grade values above the Grade average.

Inquire:
SELECT Name from StudentS
WHERE grade> (
SELECT AVG (Grade) from StudentS

Effect:

Name
1 xiaoming
2 small Yellow
3 Little miles.

2018-04-27 14:37:59

SQL (8) AVG