database Sql

Create Table Empl empno number primary licey, empnane varchar2(25), sal nunber (10,2), hiredate date. dept varchar2 (10). cender varchar2 (6}); Create Table projecth project_id nunber prnary key, enpno number neferences exp(enpno), name varchar2 (38)) : Create table job_grades\} levels varchar2 (3). lowest_sal number (10,2). highest_5al nunber (19,2)) : Insert into enp values(1, 'Vikas', 6elee, 00, '15-FEb-13'", 'IT', 'Male') insert into titp values (2, nikita: ,3500,80, '9- JAN-14'; 'HR', 'Fenale'), inisert into enp values(3,'Ashaiah', 1759.9e ' 93AN14, 'IT', 'Male' ; insert into enp values (4, 'Nikhil', 48e8, 69, '9- 3A144, 'HR', 'Male' ); Insert into etp values(5, "anish', 5500, '9-JAN-15"; 'Payrol1', 'Male'); insert into project values (1,1, 'Task Track' ); insert into project values (2,1, 'CLP' ); insert into project values ( 3,1 , 'Survey Management'); insert into project values (4,2, 'HR Management'); insert into project values (5,3, 'Task Track' ); insert into project values (6,3, ' GRS' ); insert into project values (7,3, 'DDS' ); insert into project values (8,4, 'HR Management'); insert into project values (9, null, ' GL Management'); insert into job grades values ('A', 1000,1999); insert into job grades values('B',2006, 2999); insert into job grades values ('C', 3060,3999); insert into job grades values ('D', 4000,4999); insert into job grades values ('E', 5000,5999); insert into job grades values ('F', 6000,6999); Apply the queries according to these tables, copy and paste these queries into compiler and answer the following questions Emp Project Job grades levels Lowest sal Highest sal 1- Get employee name, project name order by name from Employee and project tables for those employees which have assigned project already. 2- Get employee name, project name order by name from Employee and project tables for all employee even they have not assigned project. 3. Get employee name, project name order by name from employee and project tables for all employee if project is not assigned then display "No Project assigned" 4- Get all project name even they have not matched any empno, in left table, order by name from Employee and project tables 5- Get complete record (empname, project name) from both tables Employee and project if no match found in any table, then show NULL. 6- Write a query to find out the project name which is not assigned to any employee only no employee value from employee and project table 7. Write a query to display employee name, their salary and their level salary for each employee according to job grades table