Create reports containing the following details from the database: Q1 How many books are there in the Computer category? Use column alias for a column with the number of books, show category and the number of books in your report. Q2 Find out how many books each author wrote. Display author’s first and last name and how many books (s)he wrote. Sort by last name, then first name. Q3 Calculate the total paid for the order 1009. Consider quantity in calculations, some books may be purchased in multiple copies. Q4 Find the average retail price of books in each of the Children and Business categories, use a single query to show the average for Children and Business books (two records in the results). Q5 List customers from New Jersey and Florida who placed orders totaling over $30.Aggregate PER order, PER customer. Q6 Determine the average of ALL orders. Find the total per each order before calculating the average for all orders. Hint: Use nesting. Q7 Show the most expensive book a customer from Georgia bought. Assign a clear header to this column. Q8 How much is the least expensive book written by Smith? Combine author's first and last name in one column in the report.

Question

Create reports containing the following details from the database:

Q1 How many books are there in the Computer category? Use column alias for a column with the number of books, show category and the number of books in your report.

Q2 Find out how many books each author wrote. Display author’s first and last name and how many books (s)he wrote. Sort by last name, then first name.

Q3 Calculate the total paid for the order 1009. Consider quantity in calculations, some books may be purchased in multiple copies.

Q4 Find the average retail price of books in each of the Children and Business categories, use a single query to show the average for Children and Business books (two records in the results).

Q5 List customers from New Jersey and Florida who placed orders totaling over $30.Aggregate PER order, PER customer.

Q6 Determine the average of ALL orders. Find the total per each order before calculating the average for all orders. Hint: Use nesting.

Q7 Show the most expensive book a customer from Georgia bought. Assign a clear header to this column.

Q8 How much is the least expensive book written by Smith? Combine author's first and last name in one column in the report.

Expert Answer

Want to see the step-by-step answer?

See Answer

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

See Answer
*Response times vary by subject and question complexity. Median response time is 34 minutes and may be longer for new subjects.

Related Computer Science Q&A

Find answers to questions asked by student like you

Q: I need some help arranging these countries in a C++ program : China: 1,433,783,686 India: 1,366,417,...

A: Program Instructions:Declare two arrays and store values of countries and populations in each of the...

Q: Which of the following is NOT logically equivalent to the rest: wx~y + w~z + wxyz + w~yz w(x + ~y +...

A: Using a Karnaugh Map to find the minimal sum-of-products for the expressions we get the following (c...

Q: Assume that you will be given a *.txt file, which in the same format of RandSource.txt(attached). Th...

A: A C++ program to generate random numbers between given range is provided below;//Declare necessary h...

Q: PLEASE EXPLAIN ALL STEPS: This question has been answered multiple times, clearly by the same tutor,...

A: 1)xz + (xy + ~z)As there are three variables in the above Boolean expression there will be 23 = 8 ca...

Q: What is the difference between Python and JavaScript coding?

A: JavaScriptIt is a web programing language.it is a cross- platform language.Its code is integrated wi...

Q: CHALLENGE 3.16.2: Alphabetic replace. ACTIVITY Replace any alphabetic character with ' in 2-characte...

A: Program://include the required header files#include <iostream>#include <string>#include ...

Q: What are the different computer languages? Give a brief description of each.

A: DefinitionLanguage is the basic way of communication between the computer systems and to communicate...

Q: Please put into SOP formxz + (xy + ~z)

A: A Boolean expression is said to be in the Canonical form either it has purely min-terms or max-terms...

Q: How would I go about writing the code in the problem in the picture?

A: Program AlgorithmCreate a class Prime_Numbers and define the main() function.Initialize the required...