MySQL Aggregate function (Sum,Avg &Count) || MySQL Tutorial
On my previous video of mysql series
I have discussed about aggregate min max function
You can check the video from the above I button
Today's we will be discussing about count,avg and sum aggregate functions in mysql
Count aggregate function
The COUNT() function returns the number of rows that matches a specified criterion.
Syntax
SELECT COUNT(column_name)
FROM table_name
WHERE condition;
Avg aggregate function
The AVG() function returns the average value of a numeric column.
Syntax
SELECT AVG(column_name)
FROM table_name
WHERE condition;
Sum aggregate function
The SUM() function returns the total sum of a numeric column.
Syntax
SELECT SUM(column_name)
FROM table_name
WHERE condition;
Let us see with an example
Here we are using products table under order_info
Just as we did in our previous video
To find the no of products
Select count(ProductId)
From products
Query to find avg price of all products
Select avg(price)
From products
To find the sum of the prices of all products
Select sum(price)
From products
Let us more examples
To find the no of products where the productname is not null
Select count(Productname)
From products
To find the number of products where price is more than 19
Select count(Productname)
From products
Where price is more than =19
1
To find the no of prices whose supplierid is 2
Select sum(price)
From products
Where supplierId =2
And that's all for today Hope you all will get some help from this video
If it's so then don't forget to subscribe my channel Code with Neha and press the Bell Icon for Regular Updates
See you in the next video till then Stay Safe Stay Happy!!!
#aggregatefunctions
#aggregatefunctionsinsql
#sqlaggregatefunctionssum
#sqlaggregatefunctionavg
#sqlaggregatefunctioncount
#aggregatefunctionssql
#aggregatefunctionsindbms
#aggregatefunctionsmysql
#aggregatefunctionsinmysql
#sqlaggregatefunctions
#sqlaggregatefunctionstutorial
#mysqlcountfunction
#mysqlaggregatefunctions