Use the SaleCo ERD attached 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 customers.
– Generate a 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 cyclethat is, for the
customers who appear in the INVOICE table.
– Find a listing of customers who did not make purchases during
the invoicing period.
– Create a query to produce a summary of the value of products
currently in inventory.
