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” Plzzz give me answer

Answer 1

Answer:

On consider the terms and condition as per the statement , you have to write 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 " hope the student can simply follow and get best ideas on reading it. Each commands must be ensure well and provides best result on adding the SQL commands.