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.

Computer Science & Information Technology

You might also like to view...

Which of the following indicates your location in the folder structure?

A) Taskbar B) Menu Bar C) Content pane D) Address Bar

Computer Science & Information Technology

What technique does a VPN (virtual private network) use to transfer data securely on the Internet to a remote access server on your workplace network?

A. piping B. leasing C. subletting D. tunneling

Computer Science & Information Technology