Best practices for writing SQL (according to metabase)

Who doesn't love a good discussion about best practices? Here is an article from metabase on their recommended best practices for writing SQL. Share you opinion and recommendations.