I would appreciate MySQL - SQL help.

Objectives: This assignment focuses on the use of the aggregate functions. These functions combine all the results to perform a statistical operation that returns a single value. This assignment reinforces the following objectives: Write queries with aggregate functions: SUM, AVG, COUNT, MAX, and MIN. Use the GROUP BY clause to answer complex managerial questions. Nest aggregate functions . * Use the GROUP BY clause with NULL values -Use the GROUP BY clause with the WHERE and ORDER BY clauses Use the HAVING clause to filter out rows from a result table, This assignment uses the tables associated with the bookstore database