2
Answers

SQL Query

Ask a question
EMPLOYEE(EMPNO,EMPNAME,JOB,DEPTNO,SALARY,COMM)
DEPTT(DEPTNO,DPTNAME,LOCATION)
SALGRADE(MINSAL,MAXSAL,GRADE)

1)Display all different job types
2)List names and jobs of all clerks in department 12
3)Show EMONAME and total remuneration of all employees
4)Calculate and show minimum salary for each different job.
5)Find all departments which have more than 5 empoyees
6)Find the employees who earn the lowest salary in their department.

Answers (2)