Write the DQL queries on the university database that you have created on your computer for the following

sentences and attach the screen shots.

a$)$ Find the names of instructors with the salary between $70000$ and $100000.$

b$)$ Find All departments with the budget greater than the budget of the Physics department.

c$)$ Find the instructors with exactly four characters in their names.

d$)$ Find the ID and name of the instructor with the highest salary

e$)$ Find the ID and name of the instructor who has the highest salary in the Department of Computer

Science.

f$)$ Find the ID of the instructors who have taught at least two courses.

g$)$ Find the ID and name of the instructors who have taught at least two courses.

$4.$ Implement $2($c$)$ in mysql and add the screen shot here. Use your own data for the tables.

Each table should have at least $10$ rows.