Use of Aggregate Functions (Cont........)

Use of Aggregate Functions (Cont...)
QUERY*

    select count(distinct Company_name) from Product;
  

As Show Fig...6.1
Output

Fig... 6.1

QUERY*

    select company_name, count(*) from product group by company_name;
  

As Show Fig...6.2
Output

Fig... 6.2

QUERY*

    select MAX(quantity) from Product;
  

As Show Fig...6.3
Output

Fig... 6.3

QUERY*

    select MIN(quantity) from Product;
  

As Show Fig...6.4
Output

Fig... 6.4