How to Comment in SQL: -- and /* */, and the Two Traps That Break a Query

How to comment in SQL: the two comment syntaxes, where each one goes, the two ways commenting out a line breaks a query, and the comma habit that makes it safe.