SQL Aggregate Function | Sum, Average & Count | SQL Beginners Tutorial Part 14 скачать в хорошем качестве

SQL Aggregate Function | Sum, Average & Count | SQL Beginners Tutorial Part 14

Hello Everyone, This is the 14th part of the SQL Tutorial for Beginners. You can refer to the playlist 'SQL Tutorial' for all related videos. In this video, we are going to discuss: 1.Sum, Average, Count Function uses 2.Explained with Example 3.Aggregate Function with Group by Clause --------------------------------- SQL Query ------------------------------------------------- --SUM, AVG AND COUNT --Group by select * from dbo.sales --SUM --Example 1: Find out Total Sales select sum(sale_amount) as Total_sale from dbo.sales --Example 2: Find total sales per employee select employee_name,sum(sale_amount) as Total_sale from dbo.sales Group by employee_name --AVG --Example 1: Find average sale amount select AVG(sale_amount) as Avg_amt from dbo.sales --Example 2: Find Average sale amount per dept select AVG(sale_amount) as Avg_amt,department from dbo.sales Group by department --COUNT --COUNT(*) --COUNT(COULUMN) --Example: Find number of sales per employee select employee_name , count(*) as number_of_sales from dbo.sales group by employee_name #aggregate #function #sql #sqltutorial #sqltutorialforbeginners #IT #tutorial