1).
WAQTD number of employees getting salary less than 2000 in Deptno 10
2).WAQTD total salary needed to pay employees working as Clerk
3).WAQTD average salary needed to pay all employees
4).WAQTD number of employees having 'A' as their rst character
fi
5).WAQTD number of employees working as Clerk or Manager
6).WAQTD total salary needed to pay employees hired in Feb
7).WAQTD number of employees reporting to 7839 (Mgr)
8).WAQTD number of employees getting commission in Deptno 3
9).WAQTD avg salary, total salary, number of employees, and maximum salary given to
employees working as President.
10).WAQTD number of employees having 'A' in their names
11).WAQTD number of employees and total salary needed to pay the employees who have 2
consecutive 'L's in their names
12).WAQTD number of departments present in employee table
[Link] number of employees having character 'Z' in their names
14).WAQTD number of employees having '$' in their names
15).WAQTD total salary given to employees working as Clerk in Dept 30
16).WAQTD maximum salary given to the employees working as Analyst
17).WAQTD number of distinct salaries present in employee table
18).WAQTD number of jobs present in employee table
19).WAQTD avg salary given to the Clerk
20).WAQTD minimum salary given to the employees who work in Dept 10 as Manager or a Clerk