SELECT, part 2
SELECT, part 2（１）Aggregate the dataYou can also calculate totals, averages, etc. in the table and pick out them with"SELECT". The SQL is as follows.SELECT FunctionName(Item) FROM TableNameFor example, the SQL to pick out the math average score of all students fromthe "Grade" table is as follows.SELECT AVG(Math) FROM GradeFor example, the SQL to pick out the number of students with a math scorenot less than 80 from the "Grade" table is as follows.SELECT COUNT(*) FROM Grade WHERE Math >= 80As a result of executing the SQL, other people don't know if the item name is"COUNT (*)". In this case, you might want to give a new item name. You can give the item name by using "AS" as follows.SELECT C
0
