Question

(i) Name any two Aggragate functions of SQL.

(ii) Consider the table

          **Table: Company**

| SID | SALES |
| S101 | 20000 |
| S102 | NULL |
| S103 | 10000 |
| S104 | 15000 |

What output will be displayed by SELECT AVG ( SALES) FROM COMPANY?

Answer 1

(i) MAX, MIN

(ii) AVG ( SALES)