What other queries did you create to help Jasmine anticipate her manager's questions? What types of queries were they and what questions did they answer?
What will be an ideal response?
I created three additional queries:
One showed by subject, the average number of months books were rented in 2014 . I used an aggregate query with a Where function and an Avg function.
One showed how many customers came from each state and the average number of months they rented books. I used an aggregate query with an Avg function and a Count function.
One showed the number of books by subject rented as a percentage of all the books rented. I used subqueries and a master query with a calculation.
You might also like to view...
Text in a caption can NOT be formatted
Indicate whether the statement is true or false
The ____________________ computer architecture is characterized by sequential fetch-decode-execute cycles.
Fill in the blank(s) with the appropriate word(s).
Your first scan appears as solid black, and you consult the troubleshooting guide in the manual to see what might be going on. What advice does it offer?
After you discover a long-forgotten box of family photos in your attic, you realize that you would benefit from buying and using a scanner to convert some of the best photos to a digital format. However, you have never used a scanner before so you study the manual very carefully before you get started in your project. a. Make sure that you have selected a setting related to text with pictures rather than just text. b. Make sure that you have selected the correct file type for the original you are using. c. Make sure that you have at least a 1/4-inch margin between the photo and the edge of the scanner bed. d. Make sure that you have chosen the best resolution for the image.
How does Windows Server 2016 storage tiering feature work?
What will be an ideal response?