why are so many commands in SQL typed in all caps when they work just as well in lower case?
I am not sure there is an official rule, you might need to google that
i capitalize the (my)sql keywords, to improve readability. Then i know what are SQL keyword and what are table/column names. Which is really nice if you have more complicated queries
Writing working code and writing easy to read/understandable code are two very different things
ok, @stetim94, that makes sense.