When I write SQL queries, I sometimes get error messages and am not sure if it's because I am not using a backtick, or single quote, or double-quotation marks. I just keep trying different quotation marks until it works. Sometimes it doesn't require any.
When are you supposed to use quotes and how do you know which ones to use?