Thank you for the question.

Special thanks to Tom and Hugo for the explanation.

Nice 1 Steve. However, I don't recommend anyone to use SELECT * FROM in view.

Good math question, thanks Paul

Good question and explanation Tom.

Thanks,

Thanks for the easy one.

Good question. In real world, I always use temp table to swap the columns. May be just not want to take risk of data mess.

Thanks for the question.

Thank you for the easy question.