DBMS implementation of AGGREGATE(GROUP) functions (avg ,count, max ,min, sum)

 

 DBMS implementation of AGGREGATE(GROUP) functions (avg  ,count, max ,min, sum)

           

Create one table Book(Aname,BookName,Price,Date_of_publish,Qty)

 Insert minimum 10 records in it, then implement group functions and display the results.

 1. create a table in my sql (DBMS)

          CODE:

            create table book(

            Aname varchar(40),

             Bname varchar(40),

             price int,

            date_of_pub date,

             qty int);

                              OUTPUT:

      2. INSERT 10 RECORD IN TABLE

                                   

                                  CODE:

insert into book values ("ramil", "java",500, '2008-10-01', 6 );

       insert into book values ("ramesh", "java  fx",900, '2009-10-19', 7 );

        insert into book values ("rahul", "java core ",400, '2008-10-21', 8 );

      insert into book values ("rajesh", "java gui",500, '2008-10-11', 9 );

          insert into book values ("rinku", "java react",700, '2008-10-17', 10 );

      insert into book values ("ravish", "my sql",100, '2019-10-01', 12);

 insert into book values ("raj", "oracle ",900, '2020-10-01', 16 );

insert into book values ("rajnesh", "os",300, '2016-10-01', 5 );

        insert into book values ("rawat", "java core",900, '2018-10-01', 3 );

insert into book values ("ram", "math ",500, '2015-10-01', 9 ); 

                              

                                OUTPUT:

   1.   COUNT FUCTION:

              CODE :

            select count(*) from book;

                                     

                                    OUTPUT:

       ALSO READ:https://vknowledge2021.blogspot.com/2022/02/who-is-saint-ramanujacharya-some.html

 1.  MIN FUCTION:

    CODE :

    select min(qty) from book;

                                      OUTPUT:

   

   3.SUM FUCTION:

   CODE :

   select sum(price) from book;

 

    OUTPUT:

                                          

  ALSOREAD:https://vknowledge2021.blogspot.com/2022/02/giving-more-than-taking-motivational.html

  4.  AVG FUNCTION

  CODE:

  select avg(price) from book;

                                       

         OUTPUT:

        5. MAX FUCTION

        CODE:

        select max(qty) from book;

                                        

                                         OUTPUT:

                                          

              

IF  YOU LIKE OUR POST PLEASE COMMENT BELOW AND FOLLOW US

THANK YOU