For the second best practice, i would like to add

Give proper alignments or Indent while writing the joins to make the query more readable.

Linto