+3 votes
in Class 12 by kratos

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;

1 Answer

+4 votes
by kratos
 
Best answer

(i) Select Count (*) from Organization;

(ii) AVG ( Salary) : 7250.

...