Problem $2[30$ Marks$]$:

Consider the tables below. CSV files are provided in Moodle. The blank spaces are null values.

Employee

empno ename job mgr hiredate sal comm deptno

$7369$ SMITH CLERK $790217-12-198080020$

$7499$ ALLEN SALESMAN $769820-02-1981160030030$

$7521$ WARD SALESMAN $769822-02-1981125050030$

$7566$ JONES MANAGER $783902-04-1981297520$

$7654$ MARTIN SALESMAN $769828-09-19811250140030$

$7698$ BLAKE MANAGER $783901-05-1981285030$

$7782$ CLARK MANAGER $783909-06-1981245010$

$7788$ SCOTT ANALYST $756609-12-1982300020$

$7839$ KING PRESIDENT $17-11-1981500010$

$7844$ TURNER SALESMAN $769808-09-19811500030$

$7876$ ADAMS CLERK $778812-01-1983110020$

$7900$ JAMES CLERK $769803-12-198195030$

$7902$ FORD ANALYST $756603-12-1981300020$

$7934$ MILLER CLERK $778223-01-1982130010$

Department

deptno dname loc

$10$ ACCOUNTING NEW YORK

$20$ RESEARCH DALLAS

$30$ SALES CHICAGO

$40$ OPERATIONS BOSTON

$1.$

Create a new login group role $$FinalExam$$ with password $12345,$ login access, database creation access and replication access. Write the query below. The query can be generated by the GUI and pasted below. $[2$ Marks$]$