SQL Average Count
Average Count in SQL is used to count the aggregate sum of any field in a table.
Understand with Example
The Tutorial illustrate an simple demonstrative example ,which helps you to calculate the average count of any records specified in field. The create table help you to create a table 'Stu_Table' with table attribute like field name,data type etc.
Create Table Stu_Table
SQL statement to create table:
Insert Data into Stu_Table
The insert into add the records or rows to the created table 'Stu_Table'.
SQL statement to insert data into table:
Records in the table:
The given below Query return you the records from table 'Stu_Table' and aggregate count for the table field 'stu_name'. The Group By clause in this Query is used with aggregate functions and also specifies the group 'stu_id' where selected rows are placed.