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

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. In the university database, each course section is associated with a classroom number. So, each classroom is assigned multiple times for multiple courses over the years. Find the number of courses scheduled in a room each year.

g. From the answer to the previous question, can you find the classroom with the highest schedules over the years? Also, show the year.

h. Find the ID of the instructors who have taught at least two courses.

i. Find the ID and name of the instructors who have taught at least two courses.