Chapter 7, Problem 104P

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;

AVERAGE function:

The “AVERAGE” function is used to the return the average of the expression in a “SELECT” statement.

Syntax:

SELECT AVG (exp) FROM table_Name [WHERE condition];

ROUND keyword:

This keyword is used to round off the integer value. The syntax is given as follows:

ROUND(value,decimal_value)

Here, the “value” represents the round off value and “decimal_value” represents the number of digits that should appear after the decimal point. “decimal_value” is optional.

ORDER BY Clause:

SQL contains “ORDER BY” clause in order to sort rows. The values get sorted in ascending as well as descending order. The keyword used to sort values in ascending order is “ASC” and for descending order is “DESC”. By default, it sorts values by ascending order.

Syntax:

SELECT column_Name1, column_Name2 FROM table_Name ORDER BY column_Name2;

GROUP BY Clause:

The GROUP BY clause is used to group the result of a SELECT statement done on a table where the tuple values are similar for more than one column

Syntax:

SELECT expression1, expression2, expression_n, aggregate_function (expression) FROM table_name WHERE conditions GROUP BY expression1, expression2, expression_n;