Capitalized commands

I notice that commands (SELECT vs select) work both in lowercase and uppercase. Does it matter?

Normally no it shouldn’t affect the query itself it’s more of a suggested style that many folks follow (an attempt to be more human-friendly, it wouldn’t normally make a difference to the computer).

Different groups may follow different styles though so have a look around for any options and decide for yourself what you prefer.