Consider the table 'Organization' :
Table: Organization
OrgCode |
Salary |
C101 |
13,000 |
C102 |
5,000 |
C104 |
7,000 |
C105 |
4,000 |
(i) With SQL, how can you find the number of rows (records) in the "Organization" table?
(ii) What output will be displayed by the following SQL statement:
SELECT AVG (Salary) FROM Organization;