Question

Consider following schema Employee (E_id, E_name, Salary, Department)
Write SQL commands for following statement.
Find Summation of salary for all employees.
Display Minimum and Maximum Salary.
Display all record in descending order of Employee name.
Display employee name working in department “Quality”

Answer 1

Select sum salary from Employee;
Select max(salary), min(salary) from Employee;
Select * from Employee order by E_name desc;
Alter E_name as "Quality ";