Question: Give me the code that fits the question. Please give me the code that fits the question. It's really important. And please use the table

Give me the code that fits the question. Please give me the code that fits the question. It's really important. And please use the table shown in the screen shot that I uploaded.

Question

Update the salaries of the instructors as follows.

Increase salary by 6% for the instructors who taught at least 3 different courses (different course_id);

Increase salary by 4% for the instructors who taught exactly 2 different courses;

Increase salary by 2% for other instructors (including the instructors who did not teach).

Please use BEGIN TRAN and ROLLBACK properly (CREATE VIEW is not allowed to use; you may use the WITH clause within BEGIN TRAN and ROLLBACK). You must use the CASE expression.

Give me the code that fits the question. Please give me thecode that fits the question. It's really important. And please use thetable shown in the screen shot that I uploaded. Question Update thesalaries of the instructors as follows. Increase salary by 6% for theinstructors who taught at least 3 different courses (different course_id); Increase salary

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!