Know the view-decomposition
If you don’t know enough to…
Understand how to write the query direct to the base tables…
You don’t know enough to write the SQL!