Filtering the query results
Every query is built to retrieve a specific set of results.
When we define a query, the data can be processed and analyzed in several possible contexts:
Time: This gives information about when an event occurred; for example, the sales for the current week (a "when" business question)
Data type and specification: This gives the model specifications of the cars that were rented or sold (a "which" business question)
Measure: This gives a range or a value that is greater or less than (a "how much" business question)
Without a filtering context, a query is somewhere between serving a meaningless purpose and answering a very general question. The main idea when creating query filters is to fetch only the data that is relevant to the business question. The rule of "garbage in garbage out" applies here. By defining all the relevant conditions, we ensure that we will get accurate results as well as better performance.
Every condition is structured from the following three...
