find the total amount of bal_due
find the total amount bal_due for each city
find the total no. of client.
find maximum bal_due amount
find the maximum bal_due amount for each city
find minimum bal_due amount
find the minimum bal_due amount for each city
find the total no of client in each city
Query based on employee table of assignment - 2
write query to retrive total salary of the firm
write query to find maximum salary in the firm
write query to find minimum salary in the firm
write query to count employees in firm
write query to retrive average salary of the firm
write query to retrive total salary of the each department
write query to retrive average salary of the each department
write query to count employees in each department
write query to find maximum salary in each department
write query to find minimum salary in each department
write query to find total salary under each job title for each department
write query to find maximum salary under each job title for each department
write query to find minimum salary under each job title for each department
write query to find average salary under each title for each department
write query to count employees under each title for each department
display department wise sum of hra and sum of da of all the employee of SALES department.
Display designation wise maximum and minimum salary of all the employee of MKT and ADM department.
Display department wise average salary of all EXE and MGR of ADM and SALES department
Display department and designation wise count and sum of netsalary of all the employees whose basic salary is more than 5000.
Display department and designation wise sum of pf of all the employees whose salary is between 3000 and 9000 and working as ACC or CLK.
No comments:
Post a Comment