Question: Based on the two tables and the attributes below, write SQL commands for each question to retrieve the data from the database. tblSales InvoiceNumber InvoiceDate

Based on the two tables and the attributes below, write SQL commands for each question to retrieve the data from the database. tblSales InvoiceNumber InvoiceDate CustomerNumber Sales OrderNumber tblCustomer * CustomerNumber CustomerName CustomerAddress1 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? SELECT CustomerNumber COUNT tblCustomer
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
