Based on the two tables and the attributes below, write SQL commands for each question to retrieve the data from the database. tblSales 7 InvoiceNumber InvoiceDate CustomerNumber Sales OrderNumber tblCustomer * CustomerNumber CustomerName CustomerAddressi CustomerAddress2 CustomerCity CustomerState CustomerZip Code CustomerTelephone CustomerCreditLimit 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? Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E How many customer records are stored in the database? COUNT tblCustomer SELECT FROM Required A Required B > Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E List customers who live in New York. SELECT FROM WHERE 'New York' Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E List customers with credit limits greater than $50,000. SELECT FROM WHERE 50,000 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E List sales transactions made in July, 2018. SELECT tblCustomer CustomerCity Customer CreditLimit tolSales Customer Number FROM WHERE AND BETWEEN #7/1/2018# AND #7/31/2018# 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 tbl Sales GROUP BY Based on the two tables and the attributes below, write SQL commands for each question to retrieve the data from the database. tblSales 7 InvoiceNumber InvoiceDate CustomerNumber Sales OrderNumber tblCustomer * CustomerNumber CustomerName CustomerAddressi CustomerAddress2 CustomerCity CustomerState CustomerZip Code CustomerTelephone CustomerCreditLimit 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? Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E How many customer records are stored in the database? COUNT tblCustomer SELECT FROM Required A Required B > Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E List customers who live in New York. SELECT FROM WHERE 'New York' Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E List customers with credit limits greater than $50,000. SELECT FROM WHERE 50,000 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E List sales transactions made in July, 2018. SELECT tblCustomer CustomerCity Customer CreditLimit tolSales Customer Number FROM WHERE AND BETWEEN #7/1/2018# AND #7/31/2018# 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 tbl Sales GROUP BY
