Queries express the questions you want your data to answer.
When you work with queries, you need to keep in mind the questions that you want your data to answer. The better you state the question, the more precisely you can define the query.
Here are some examples that will help you think of others.
A corporate sales and products database
- What's the company's most popular sales item in the United Kingdom?
- What would we gain and lose if we dropped our slowest-moving product line?
- What item costs the most to make?
A personal media collection database
- How many of my DVDs are on loan to my friends?
- Which CDs contain my all-time favorite tunes?
A sports league database
- Which team had the highest total score in all games last year?
- Who ordered team jerseys this year, and what sizes do they need?
What questions do you want your data to answer?