Create table EMP and DEPT with the below mentioned structureStructure for EMP tableEmpIDNUMBER(4)DeptIDVARCHAR2(10)EmpNameCHAR(10)JobCHAR(10)HireDate DATESalary NUMBER(7, 2)Commission NUMBER (7, 2)Structure for DEPT tableDeptId VARCHAR2(10)Deptname VARCHAR2(20)No_of_Faculties NUMBER(2)In table EMP : EmpID should be the Primary Key and DeptID should be the foreign key.In table DEPT : DeptId should be the primary key. a) Find out the number of employees having “manager” as job. b) Display only the jobs with maximum salary greater than or equal to 3000 c) Find all those employees whose job does not start with ‘M’. Find the names of the employees who are Managers and their date of joining is after “02-Jan-2006”.
Create table EMP and DEPT with the below mentioned structureStructure for EMP tableEmpIDNUMBER(4)DeptIDVARCHAR2(10)EmpNameCHAR(10)JobCHAR(10)HireDate DATESalary NUMBER(7, 2)Commission NUMBER (7, 2)Structure for DEPT tableDeptId VARCHAR2(10)Deptname VARCHAR2(20)No_of_Faculties NUMBER(2)In table EMP : EmpID should be the Primary Key and DeptID should be the foreign key.In table DEPT : DeptId should be the primary key.
a) Find out the number of employees having “manager” as job.
b) Display only the jobs with maximum salary greater than or equal to 3000
c) Find all those employees whose job does not start with ‘M’.
Find the names of the employees who are Managers and their date of joining is after “02-Jan-2006”.
Step by step
Solved in 3 steps with 6 images