AVG « Aggregate Functions « SQL / MySQL






  1. SQL / MySQL
  2. Aggregate Functions
  3. AVG
1.To display an average value of zero in that case, modify the query to test the value of AVG( ) with IFNULL( )
2.AVG() Function averages the values returned by a specified expression.
3.Returning the Average, Minimum, and Total Values with AVG( ), MIN( ), and SUM( )
4.Get the average price
5.Average length
6.How much you paid for each author's books, in total and on average
7.Find the average sales amount per sales quarter.
8.How many miles did the drivers in the mytable table travel? What was the average miles traveled per day?