ROLLBACK example with mistake
I believe you have a mistake in ROLLBACK example. If you changed name to 'Johnson" and made COMMIT then you are not able to get back to 'Winnfield' anymore, right?
Thanks for reaching out.
In Minute 1:50 we display Winnfield as a reference to what ROLLBACK; would have displayed otherwise; i.e. if COMMIT; had not been executed. You are right when you say "the last name should not change to 'Winnfield' since the change from 'Winnfield' to 'Johnson' occurred BEFORE the last commit". You could also think of it as: "if there was no commit executed, ROLLBACK; would have led to "Winnfield" - the last non-committed state.
Hope this helps.