Chapter 5. It's About the Question
"It's not about the query, it's about the question." That's one of my favorite sayings when it comes to writing SQL. Regardless of your level of proficiency, writing SQL well is as much about questions as it is about queries.
There are many ways that questions play an important role when writing SQL. First, understanding the question behind the query is often more important than the query syntax itself. If you start with the question the SQL is intended to answer, you will be more likely to think through and understand how to best formulate the query to get the desired result. Second, it is critical to be able to ask good questions to clarify what the SQL is intended to do and to gather all the pertinent ...