Hi! I am not sure how to to the Required E part, think you!

Based on the two tables and the attributes below, write SQL commands for each question to retrieve the data from the database. tblSales tblCustomer InvoiceNumber CustomerNumber InvoiceDate CustomerName CustomerNumber CustomerAddress1 SalesOrderNumber CustomerAddress2 CustomerCity CustomerState CustomerZipCode CustomerTelephone CustomerCreditLimit CustomerPrimaryContact Required: a. How many customer records are stored in the database? b. List customers who live in New York. c. List customers with credit limits greater than $50,000. d. List sales transactions made in July, 2018. e. What's the number of total sales transactions made to each customer?Required: a. How many customer records are stored in the database? b. List customers who live in New York. c. List customers with credit limits greater than $50,000. d. List sales transactions made in July, 2018. e. What's the number of total sales transactions made to each customer? Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E What's the number of total sales transactions made to each customer? SELECT COUNT AS Total FROM WHERE tblSales GROUP BY