There are many pitfalls when you begin to create new queries. You can find some of them by yourself. It would be better if you can avoid them before your start.
Here is a useful list of pitfalls I found that should be avoided:
These topics are discussed one by one.
One of the most common problems for query writing is related to data structure. A new query learner tends to start building the ...