OUESTION $3$

DEPT

$\backslash$table$[[$DEPTNO$,$DNLME,LOC$],[10,$ACCOUNTING,NEW YORK$],[20,$RESEARCH,DALLAS$],[30,$SALES,CHICAGO$],[40,$OPERAIIONS,BOSTON$]]$

EMP

$\backslash$table$[[$EMPNO$,$ENAME,JOB,MGR$,$HIREDATE,SAL,COMM,DEPTNO$],[7369,$SMITH,CLERK,$7902,17-$DEC$-80,800,,20],[7499,$ALLEN,SALESMAN,$7698,20-$FEB$-81,1600,300,30],[7521,$WARD,SALESMAN,$7698,22-$FEB$-81,1250,500,30],[7566,$JONES,MANAGER,$7839,02-$APR$-81,2975,,20],[7654,$MARTIN,SALESMAN,$7698,28-$SEP$-81,1250,1400,30],[7698,$BLAKE,MANAGER,$7839,01-$MAY$-81,2850,,30],[7782,$CLARK,MANAGER,$7839,09-$JUN$-81,2450,,10],[7788,$SCOTI,ANALYST,$7566,19-$APR$=87,3000,,20],[7839,$KING,PRESIDENT,,$17-$NOV$-81,5000,,10],[7844,$TURNER,SALESMAN,$7698,08-$SEP$-81,1500,0,30],[7876,$ADAMS,CLERK,$7788,23-$MAY$-87,1100,,20],[7900,$JAMES,CLERK,$7698,03-$DEC$-81,950,,30],[7902,$FORD,ANALYST,$7566,03-$DEC$-81,3000,,20],[7934,$MIUER,CLERK,$7782,23-$JAN$-82,1300,,10]]$

USE THESE TWO TABLES TO WRITE SQL STATEMENTS FOR THE FOLLOWING:

a$)$ Display all information in the tables EMP

$(2)$

b$)$ Display the names and salaries of all employees with a salary greater than $2000.$

$(3)$

c$)$ Display the names of all employees with an $\text{'}A\text{'}$ in their name.

$(3)$

d$)$ Display the names and hire dates of all employees in the order they were hired.

$(3)$

e$)$ Display the department number and number of clerks in each department.

$(3)$

f$)$ Display the name of each employee with his department name.

$(3)$

g$)$ Display the names and job titles of all employees with the same job as Jones.

$(3)$