lab3

1 CREATE TABLE Employee (

 E_id INT,

 E_name VARCHAR(50),

 Age INT,

 Salary DECIMAL(10,2) );

DBMS Manual

Dept. of CSE, RNSIT Page 4

2 SELECT COUNT(E_name) AS Num_of_Employees

FROM Employee;

3 SELECT MAX(Age) AS Max_Age

FROM Employee;

4 SELECT MIN(Age) AS Min_Age

FROM Employee;

5 SELECT E_name, Salary

FROM Employee

ORDER BY Salary ASC;

6 SELECT Salary, COUNT(*) AS Num_of_Employees

FROM Employee

GROUP BY Salary;