In the video example, we changed the last_name from 'Winnfield' to 'Johnson' using the UPDATE statement and then used a COMMIT statement.
When we used a ROLLBACK statement, the video showed the last_name getting changed back to Winnfield.
Now my confusion is:
Later in the video, you defined ROLLBACK as the statement which reverts the changes back to the last non-committed state and in my opinion, the video shows the changes getting reverted back to the last committed state.
So I think the ROLLBACK statement shouldn't be able to revert back to 'Winfield'. So, one of us is wrong so please clarify.