Use the SaleCo ERD listed below and the provided SQL scripts to construct its relational database and answer the following queries:

Write a query to count the number of invoices.

Write a query to count the number of customers with a customer balance over $$500.$

Generate a listing of all purchases made by the customers

Generate the listing of customer purchases, including the subtotals for each of the invoice line numbers

List the balance characteristics of the customers who have made purchases during the current invoice cycle$-$that is$,$ for the customers who appear in the INVOICE table.

Find the listing of customers who did not make purchases during the invoicing period.

Create a query to produce the summary of the value of products currently in inventory.