Answer the following questions using SQL statements.

a) Display the IDs and names of all instructors who have never taught a course.

b) Show the names of the students whose names include substring 'cr' twice or end

with 'ng'.

c) Find the IDs, names of all the students who take more than 10 credits in a

semester.

d) Show IDs and names of the students if they do not take any course that is offered by the 'CSCI'

department.

e) For each department, show both the department budget and the remaining department budget

after paying all its instructor's salaries.

f) Show the ID of the students having taken the most courses offered by the 'CSCI' department.