Based on the two tables and the attributes below. write SQL commands for each question to retrieve the data from the database. tb Sales InvoiceNumber InvoiceDate Customer Number Sales Order Number tblCustomer Customer Number Customerliame CustomerAddress Customer Address2 CustomerCity Customerstate Customer Zip Code CustomerTelephone Customer Creditimit Customer Primary Contact 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 Required B Required c Required D Required E How many customer records are stored in the database? SELECT COUNT CustomerName tblCustomer FROM Regleda Required B > at nces Required A Required B Required C Required D Required E List customers who live in New York. SELECT CustomerZipCod FROM InvoiceNumber tblCustomer CustomerCity WHERE 'New York Complete this question by entering your answers in the tabs below. Required A Required B Required Required D Required E List customers with credit limits greater than $50,000. SELECT FROM WHERE 50,000 1 Required A Required Required Required D Required E List sales transactions made in July, 2018 SELECT FROM WHERE AND BETWEEN 7/1/2018 AND 07/31/2018