Semester $452$

Instructions:

Create following table with your name.

Put screen shots for each Question.

If table is not created wit your name you will lose marks

Name:

Academic No:

Q$1$: Use SQL line command to create following table with your name $(2$ Mark$).$ Select the column data type as per your choices.

$\backslash$table$[[$empno$,$ename,Job,Job$\_$id$,$Sal,City$],[1,$Saara,Manager,$1,3000,$Abha$],[2,$Nisar,secretary$,2,4000,$Jeddah$],[3,$Fatima,salesman,$3,20000,$Abha$],[4,$Fahad,salesman,$3,$null,Najran$],[5,$Areej,Prof,$4,15000,$Riyadh$],[6,$Salma,Manager,$1,7000,$Jeddah$]]$

Q$2$: Write SQL commands to Implement the following:

a$)$ Show the name of Employees starting from letter F$.(0\mathrm{.}5)$

b$)$ Show the name of Employees who are manager and salary is less than $5000.(0\mathrm{.}5)$

c$)$ Write a query that finds the total, highest, lowest and average salaries that paid for employees per job ids. $(0\mathrm{.}5)$

d$)$ How many job ids that have been occupied in the company? Please avoid repetition of jobs.$(0\mathrm{.}5)$

e$)$ How many Employees belong to Abha. $(0\mathrm{.}5)$

f$)$ Return employees by descending order of their name. $(0\mathrm{.}5)$