IMPLEMENT THE FUNCTIONS MAX(),MIN(),AVG(),COUNT() IN SQL

SQL>  create table product(Pid int primary key,pname varchar (30),Price int);

Table created.

SQL> insert into product values(1,'Monitor',6000);

1 row created.

SQL> insert into product values(3,'Keyboard',500);

1 row created.

SQL> insert into product values(4,'Printer',6500);

1 row created.

SQL> select * from product;

       PID PNAME                               PRICE

---------- ------------------------------ ----------

         1 Monitor                              6000

         3 Keyboard                            500

         4 Printer                                 6500

SQL> select max(price) from product;

MAX(PRICE)

----------

      6500

SQL> select min(price) from product;

MIN(PRICE)

----------

       500

SQL> select avg(price) from product;

AVG(PRICE)

----------

4333.33333

SQL> select count(price) from product;

COUNT(PRICE)

------------

           3

SQL> commit;

Commit complete.