Describe your issue
"Hello, I’m encountering an issue with this problem. According to the problem description, ROLLBACK TO S1 should restore the original salaries of the faculty members. However, when I execute ROLLBACK TO S1; followed by SELECT * FROM Faculty;, the salary column contains NULL values for all rows. This indicates that the S1 savepoint was created before(it was mentioned in the previous query) the salary data was populated in the Faculty table.
This makes it impossible to complete the subsequent steps of reducing the salary and calculating the average, as these operations require the salary column to contain numerical values.
Could you please clarify whether this behavior is intended? If S1 is indeed supposed to contain the initial salaries, there may be an issue with the problem setup or the database state. If not, the problem description should be updated to reflect the actual behavior of the ROLLBACK and provide alternative instructions for obtaining the initial salary data.
Thank you for your time and attention to this matter."
Screenshot
Task-7 Rolling Back and Updating Salaries in SQL