create database employee; use employee; create table dept ( deptid INT primary key, dname VARCHAR(50), loc VARCHAR(7) ); insert into dept (deptid, dname, loc) values (1, 'Human Resources', 'Block 2'); insert into dept (deptid, dname, loc) values (2, 'Business Development', 'Block 2'); insert into dept (deptid, dname, loc) values (3, 'Research and Development', 'Block 3'); insert into dept (deptid, dname, loc) values (4, 'Engineering', 'Block 3'); insert into dept (deptid, dname, loc) values (5, 'Marketing', 'Block 3'); insert into dept (deptid, dname, loc) values (6, 'Services', 'Block 1');

create table emp ( id INT primary key, ename VARCHAR(50), deptno INT references dept(deptid), age INT, salary DECIMAL(6,2), hiredate DATE ); insert into emp (id, ename, deptno, age, salary, hiredate) values (1, 'Hersh Melby', 4, 53, 5274.66, '2020-08-16'); insert into emp (id, ename, deptno, age, salary, hiredate) values (2, 'Jazmin Southard', 5, 30, 7058.63, '2020-02-10'); insert into emp (id, ename, deptno, age, salary, hiredate) values (3, 'Lenard Baume', 4, 56, 1951.93, '2018-07-27'); insert into emp (id, ename, deptno, age, salary, hiredate) values (4, 'Lucky Bertin', 4, 46, 4882.44, '2017-03-18'); insert into emp (id, ename, deptno, age, salary, hiredate) values (5, 'Gardener Beeching', 3, 45, 5177.25, '2017-01-30'); insert into emp (id, ename, deptno, age, salary, hiredate) values (6, 'Fanchette Havile', 4, 64, 6839.26, '2020-04-23'); insert into emp (id, ename, deptno, age, salary, hiredate) values (7, 'Kane Monkton', 5, 20, 5108.73, '2019-10-01'); insert into emp (id, ename, deptno, age, salary, hiredate) values (8, 'Adan Greaterex', 6, 34, 3936.62, '2020-12-12'); insert into emp (id, ename, deptno, age, salary, hiredate) values (9, 'Katusha Sitford', 4, 64, 8836.7, '2020-05-01'); insert into emp (id, ename, deptno, age, salary, hiredate) values (10, 'Jake Shea', 1, 35, 8092.36, '2018-01-01');

Display employee name and department name of the employee where employee name is Jake Shea.