Fred Smith started an online textbook store in $2023.$ As Fred's friend, you created the following relational database: Instructions:

Use the following template to complete required items $1-3$ of this problem

Write your answer like a programmer $($i$.$e$.,$ exact spellings, specific commands, etc.$)$

Extra space $($i$.$e$,$ rows$)$ have been added

Upload your completed template into the homework assignment in Connect.

Please be sure to include your name above $($overwrite the blue font$)$

Potential hint: If you believe you have multiple "WHERE" criteria, you can use operators such as "AND", $"$OR$".$

SQL query $1$

SQL query $2$

SQL query $3$

Additional data dictionary information:

Author table: the Author ID attribute is numeric while the remaining attributes are text.

Author$\_$Book table: both fields are numeric.

Book table: the Book ID and Year attributes are numeric while the remaining four attributes are text. The Area attribute represents the subject area $($e$.$g$.,$ accounting, biology, chemistry, economics, finance, etc.$)$

Sales$\_$Line$\_$Item table: The Sales Date attribute's data type is date$/$time$,$ the Customer ID$,$ Book ID$,$ and Quantity attributes are numeric, while the Unit Price attribute is currency.

Customer table: the Customer ID attribute is numeric while the remaining attributes are text.

Using the attached template, write three SQL queries that will return:

The average unit price of all sales for each different $[$subject$]$ area.

The total quantity of books sold to each customer. The query output should also include the customers' name information and email address. Customers who purchased the largest quantities should appear first, while customers who purchased the fewest quantities should appear last.

A list providing the number of sales transactions, total quantity sold, and the average unit price, by publisher, for the calendar fourth quarter of $2023.$ The list should be sorted alphabetically by publisher.