I think one key mistake I've seen a lot of people make in the industry is when creating complex queries with joins.
Also, one other thing to note is if you are creating the database schema, a badly defined schema can lead to very inefficient and deformed queries that will cause more harm than good.
Great article btw :)