Hello this quesion is related to Database Fundementals Please don\'t answer with

Question

Hello

this quesion is related to Database Fundementals

Please don't answer with your handwriting

thank you

Write the following inserts, deletes or updates in SQL, using the university schema. a) Increase the salary of each instructor in the Finance department by 10%. b) Delete all courses that have never been offered (that is, do not occur in the section relation. c) Insert every student whose tot_cred attribute is greater than 150 as an instructor in the same department, with a salary of $25,000

Explanation / Answer

a) UPDATE Instructor SET salary = salary * 1.1

c) INSERT INTO Instructors (name, deptName, salary)
SELECT name, deptName, 25000 FROM students WHERE tot_cred > 150;

**Comment for any further queries.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---