Functions in Sql

Functions in SQL
Since we have started dealing with numbers, the next natural question to ask is if it is possible to do math on those numbers, such as summing them up or taking their average. The answer is yes! SQL has several arithematic functions, and they are:
• AVG: Average of the column.
• COUNT: Number of records.
• MAX: Maximum of the column.
• MIN: Minimum of the column.
• SUM: Sum of the column.
The syntax for using functions is,
SELECT "function type" ("column_name")
FROM "table_name"
Examples of how these functions are used are presented individually in the next few pages.
In addition to using functions, it is also possible to use SQL to perform simple tasks such as addition (+) and subtraction (-). For character-type data, there are also several string functions available, such as concatenation, trim, and substring functions. Different RDBMS vendors have different string functions implementations, and it is best to consult the references for your RDBMS to see how these functions are used.

Aggregate Functions:

SQL uses the AVG() function to calculate the average of a column. The syntax for using this function is,

SELECT AVG("column_name")
FROM "table_name"

For example, if we want to get the average of all sales from the following table,

Table Store_Information

store_name	Sales	Date
Los Angeles	$1500	Jan-05-1999
San Diego	$250	Jan-07-1999
Los Angeles	$300	Jan-08-1999
Boston	$700	Jan-08-1999

we would type in

SELECT AVG(Sales) FROM Store_Information