Using Application Express, complete the following Hands$-$On Assignments:

Q$1$ 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.

Q$2$ Find out how many books each author wrote. Display the author's first and last name and how many books $($s$)$he wrote. Sort by last name, then first name.

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

Q$4$ 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$).$

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

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

Q$7$ Show the retail price of the most expensive book a customer from Georgia has bought. Assign a clear header

$?$

to this column. Show just one column in the report!