give the screenshot of these code from the SQL

$1-$List the Names and Jobs of all employees whose Manager is employee number $7698.$

Code:

SELECT e$.$Ename AS "Employee Name", e$.$Job AS "Job"

FROM EMPLOYEES e

WHERE e$.$MGR $=7698$;

$2-$List the details of all employees hired in $1982($use LIKE in the query$).$

Code:

SELECT employee$\_$id$,$ last$\_$name, hire$\_$date

FROM employees

WHERE hire$\_$date LIKE $\text{'}\%1982\%\text{'}$;

$3-$Produce a list of all employees whose job titles have $\text{'}$ES$\text{'}$ in them, showing empno,

ename, job

Code:

SELECT empno, ename, job

FROM employees

WHERE job LIKE $\text{'}\%$ES$\%\text{'}$;

$4-$List the employees whose names either start with $\text{'}$A$\text{'}$ or end with $\text{'}$S$\text{'}.$

Code:

SELECT employee$\_$name

FROM employees

WHERE employee$\_$name LIKE $\text{'}$A$\%\text{'}$ OR employee$\_$name LIKE $\text{'}\%$S$\text{'}$

ORDER BY employee$\_$name;

$5-$List the department name and city of all departments that have the letter $\text{'}E\text{'}$ in their

department's name.

Code:

SELECT department$\_$name, city

FROM departments d

JOIN locations $1$ ON d$.$location$\_$id $=$ l$.$location$\_$id

WHERE department$\_$name LIKE $\text{'}\%$E$\%\text{'}$;

$6-$Produce a list of all employees who are either Analysts, Managers or Clerks $($Use IN in

the query$)$

Code:

SELECT empno, ename, job

FROM employees

WHERE job IN $(\text{'}$ANALYST$\text{'},$ 'MANAGER', 'CLERK'$)$;