SQL - LEVEL2

35. display the total salary drawn by analyst working in dept no 40.

36. display the names of employees in order of salary i.e the name of the employee earning lowest salary should appear first.

37. display the names of employees in descending order of salary.

38. display the details from emp table in order of emp name.

39. display empno,ename,deptno and sal.sort the output first based on name and within name by deptno and within deptno by sal;

40. display the name of the employee along with their annual salary(sal*1).the name of the employee earning highest annual salary should appear first.

41. display name,sal,hra,pf,da,total sal for each employee.the output should be in the order of total sal,hra 15% of sal,da 1 0% of sal,pf 5% of sal total sal will be (sal*hra*da)-pf

42. )display dept numbers and total number of employees within each group

43. display the various jobs and total number of employees with each job group

44. display department numbers and total salary for each department

45. dsplay department numbers and maximum salary for each department.

47)display each job along with minimum sal being paid in each job group.

48. display the department numbers with more than three employees in each dept

49. display the various jobs along with total sal for each of the jobs where total sal is greater than 40000.

50. display the various jobs along with total number of employees in each job.the output should contain only those jobs with more than three employees.