I'm a newbie, so I learned a couple of things from this question. For example, I didn't realize that I could use SELECT the same way SET is used. (Although, if I change the lines that are supposed to be assigning a value to a variable to SET, I get an error, thus alerting me to the problem. So, I think I'll keep using set.)
The question prompted me to do further research, and I found this helpful page that let me know that using SELECT to assign values is not a part of ANSI standards, but it can be used to assign values to multiple variables at the same time :
Thanks for the question of the day, and for prompting me to look further into using SELECT in new ways!