write a SQL statement that Updates the salaries of faculty as their current sala
ID: 3596812 • Letter: W
Question
write a SQL statement that Updates the salaries of faculty as their current salary + 10000 · (the number of courses they are teaching).
book bookid title Introduction of Algorithms rice total copies 84.66 Database System Concepts74.99 Stochastic Calculus for Financ41.02 Stochastic Calculus for Finance II 55.22 course title Algorithms DB Organization Advanced DB Organization Math Finance I Math Finance II faculty enroll studentid courseid student studentid facultyid name gpa Tom 3.3 John3.8 Mary 3.0 Kris 3.6 Alex3.5 James 70000 Sarah 60000 ay 80000 Rache 70000 Pau85000 book_ checkout bookid studentid 2017-08-29 2017-09-02 2017-09-07Explanation / Answer
update faculty set salary=salary+10000;
commit
If run the above query it will update all salaries presnt in faculty table currentsalary +10000
Do remeber commit once updated
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.