SQL Getting Started Tutorial: SQL AVG () function

SQL Getting Started Tutorial: SQL AVG () function

AVG () function
AVG () function returns the average value of the values column.

AVG () syntax for the database

SELECT AVG (column_name) from table_name

Let's look at a table first.

 
   
    TD>2008/10/23 
      
 
    
    
 
     
 
      
_id< /th> 
 
      
orderdate 
 
      
orderprice 
 
      
customer 
 
     
 
     
 
      
 1 
 
      
 2008/11/12 
 
      
 1000 
 
      
 Hansen 
 
     
 
     
 
      
 2 
 1600 
 
      
 Nilsen 
 
     
 
     
 
      
 3 
 
      
 2008/09/02 
 
      
 7 
 
      
 Hansen 
 
     
 
     
 
      
 4 
 
      
 2008/09/03 
 
      
 
 
      
 Hansen 
 
     
 
     
 
      
 5 
 
      
 2008/08/30 
 
      
 
 
      
 Jensen 
 
     
 
     
 
      
 6 
 
      
 2008/10/04 
 
      
 
 
      
 Nilsen 
 
     
 
    
 
   
   
 

 
   
   

    
     Now, we are looking for the average value of the "Orderprice" field. 
    
    
 
    
    
 We use the following SQL statement: 
    
    
 
    
    
   
 
    
    
 SELECT AVG (orderprice) as Orderaverage from Orders 
 
    
    
  
      
 output results. 
 
 
      
      
 
       
       
 
        
 
         
orderaverage 
 
        
 
        
 
         
 950 
 
        
 
       
 
      
      
 
 
  
 
 
      
      
 
       
       
 
        
 
         
customer 
 
        
 
        
 
         
 Hansen 
 
        
 
        
 
         
 Nilsen 
 
        
 
        
 
         
 Jensen