Chapter 1, Problem 12SCG

Program Plan Intro

SELECT statement:

It is used to retrieve information from the table or database. The syntax for the “SELECT” statement is given below:

Syntax:

SELECT * FROM table_Name;

AVG() function:

The “AVG()” function is used to get the average of all the values from the column.

Syntax:

SELECT AVG(column_Name) FROM table_Name;