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!
Oh, and by the way…