Question

Consider table Employees and EmpSalary and write output for the following SQL

queries.

i) SELECT Firstname, Salary FROM Employees, EmpSalary WHERE

Designation = “Salesman” AND Employee. Emp_Id=EmpSalary.Emp_Id;

ii) SELECT count(DISTINCT Designation) FROM EmpSalary;

iii) SELECT Designation, sum(Salary) FROM EmpSalary GROUP BY

Designation HAVING count(*)>2;

iv) SELECT sum(Benefits) FROM EmpSalary WHERE Designation= “Clerk”;

v) SELECT * FROM EmpSalary ORDER BY Salary;​

Answer 1

Answer:

Designation HAVING count(*)>2;