Question: Based on the two tables and the attributes below, write SQL commands for each question to retrieve the data from the database. tbiSales Invoicember InvoiceDate
Based on the two tables and the attributes below, write SQL commands for each question to retrieve the data from the database. tbiSales Invoicember InvoiceDate CustomerNumber Sales Order Number tblCustomer y Customerlumber Customeriame Customer Address CustomerAddress2 CustomerCity Customerstate CustomerZip Code CustomerTelephone CustomerCreditLimit Customer PrimaryContact 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? / ICOUNT COUNT SELECT FROM
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
