ORACLE AVG FUNCTION

ORACLE AVG FUNCTION

                               avg function calculates avg of the values supplied

QUERY: Calculate Average Weight of the Person.

SQL> desc person;
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------
 ID                                                             NUMBER(2)
 NAME                                                           VARCHAR2(20)
 DOB                                                            DATE
 EMAIL                                                          VARCHAR2(20)
 WEIGHT                                                         NUMBER(5,2)

SQL> select * from person;

        ID NAME                 DOB       EMAIL                    WEIGHT
---------- -------------------- --------- -------------------- ----------
         1 Peter                12-DEC-97 1@gmail.com                 100
         6 life style           11-SEP-97
         2 shyam purru          12-JAN-00 2@gmail.com                 111
         3 Jho                  01-NOV-02 3@gmail.com                 133
         4 Jhony                30-AUG-60 4@gmail.com              133.44
         5 pearso               21-APR-13 5@gmail.com              150.01

6 rows selected.

SQL> select avg(weight) from person;

AVG(WEIGHT)
-----------
     125.49

 

QUERY: GET AVERAGE SALARY FROM EACH DEPARTMENT

SQL> select DEPARTMENT_ID,AVG(SALARY) from hr.employees
  2  group by DEPARTMENT_ID;

DEPARTMENT_ID AVG(SALARY)
------------- -----------
          100  8601.33333
           30        4150
                     7000
           90  19333.3333
           20        9500
           70       10000
          110       10154
           50  4376.08889
           80  8955.88235
           40        6500
           60        5760

           10        4400

12 rows selected.