Homework Help is Here – Start Your Trial Now!
Engineering
Data Structures and Algorithms
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 Customer Number SalesOrderNumber tblCustomer CustomerNumber CustomerName CustomerAddress1 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?

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 Customer Number SalesOrderNumber tblCustomer CustomerNumber CustomerName CustomerAddress1 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?

icon
Related questions
Question
Based on the two tables and the attributes below. write SQL commands for each question to retrieve the data from the database. tblSales V InvoiceNumber InvoiceDate CustomerNumber SalesOrderNumber tblCustomer 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 CustomerNumber CustomerName CustomerAddresst CustomerAddress2 CustomerCity CustomerState Complete this question by entering your answers in the tabs below. SELECT FROM WHERE CustomerZipCode CustomerTelephone CustomerCreditLimit CustomerPrimaryContact tblCustomer tblSales tblSales InvoiceDate List sales transactions made in July, 2018. Required D CustomerNumber ✔InvoiceNumber ✔BETWEEN Required E # 7/1/2018# x CustomerName x tblSales ✔tblCustomer = ✔tblCustomer AND #7/31/2018# < Required C * InvoiceNumber ✔InvoiceNumber Required E > >Ⓡ XAND x
Transcribed Image Text:Based on the two tables and the attributes below. write SQL commands for each question to retrieve the data from the database. tblSales V InvoiceNumber InvoiceDate CustomerNumber SalesOrderNumber tblCustomer 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 CustomerNumber CustomerName CustomerAddresst CustomerAddress2 CustomerCity CustomerState Complete this question by entering your answers in the tabs below. SELECT FROM WHERE CustomerZipCode CustomerTelephone CustomerCreditLimit CustomerPrimaryContact tblCustomer tblSales tblSales InvoiceDate List sales transactions made in July, 2018. Required D CustomerNumber ✔InvoiceNumber ✔BETWEEN Required E # 7/1/2018# x CustomerName x tblSales ✔tblCustomer = ✔tblCustomer AND #7/31/2018# < Required C * InvoiceNumber ✔InvoiceNumber Required E > >Ⓡ XAND x
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer