Write a query to display the first name, last name, street, city, state, and zip code of any customer who purchased a Foresters Best brand top coat between July 15, 2017, and July 31, 2017. If a customer purchased more than one such product, display the customer’s information only once in the output. Sort the output by state, last name, and then f

Programming with Microsoft Visual Basic 2017
8th Edition
ISBN:9781337102124
Author:Diane Zak
Publisher:Diane Zak
Chapter11: Sql Server Databases
Section: Chapter Questions
Problem 4E
icon
Related questions
Question
100%
  1. Write a query to display the first name, last name, street, city, state, and zip code of any customer who purchased a Foresters Best brand top coat between July 15, 2017, and July 31, 2017. If a customer purchased more than one such product, display the customer’s information only once in the output. Sort the output by state, last name, and then first name
LGCUSTOMER
LGBRAND
PK
Cust_Code
PK Brand ID
Cust_Fname
Cust Lname
Cust_Street
Cust_City
Cust_State
Cust ZIP
Cust_Balance
Brand_Name
Brand_Type
includes
places
LGPRODUCT
LGLINE
PK
Prod SKU
LGINVOICE
PK,FK1 Inv_ Num
Line_Num
Prod_Descript
Prod_Type
Prod_Base
Prod_Category
Prod_Price
Prod_QOH
Prod_Min
FK1 Brand_ID
PK
Inv Num
PK
appears on
contains
FK2
FK1 Cust_Code
Inv Date
Inv_Total
FK2 Employee_ID
Prod_SKU
Line_Qty
Line_Price
completes
provided by
LGEMPLOYEE
PK
Emp Num
LGSALARY_HISTORY
LGSUPPLIES
Emp_Fname
Emp_Lname
Emp_Email
Emp_Phone
Emp_Hiredate
Emp_Title
Emp_Comm
FK1 Dept_Num
PK,FK1 Emp_Num
Sal_From
PK,FK1 Vend_ID
PK,FK2 Prod_SKU
has
PK
Sal End
Sal_Amount
provides
employs
mankges
LGVENDOR
PK Vend ID
LGDEPARTMENT
Vend_Name
Vend_Street
Vend_City
Vend_State
Vend_ZIP
PK
Dept_Num
Dept_Name
Dept_Mail_Box
Dept_Phone
FK1 Emp_Num
Transcribed Image Text:LGCUSTOMER LGBRAND PK Cust_Code PK Brand ID Cust_Fname Cust Lname Cust_Street Cust_City Cust_State Cust ZIP Cust_Balance Brand_Name Brand_Type includes places LGPRODUCT LGLINE PK Prod SKU LGINVOICE PK,FK1 Inv_ Num Line_Num Prod_Descript Prod_Type Prod_Base Prod_Category Prod_Price Prod_QOH Prod_Min FK1 Brand_ID PK Inv Num PK appears on contains FK2 FK1 Cust_Code Inv Date Inv_Total FK2 Employee_ID Prod_SKU Line_Qty Line_Price completes provided by LGEMPLOYEE PK Emp Num LGSALARY_HISTORY LGSUPPLIES Emp_Fname Emp_Lname Emp_Email Emp_Phone Emp_Hiredate Emp_Title Emp_Comm FK1 Dept_Num PK,FK1 Emp_Num Sal_From PK,FK1 Vend_ID PK,FK2 Prod_SKU has PK Sal End Sal_Amount provides employs mankges LGVENDOR PK Vend ID LGDEPARTMENT Vend_Name Vend_Street Vend_City Vend_State Vend_ZIP PK Dept_Num Dept_Name Dept_Mail_Box Dept_Phone FK1 Emp_Num
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Single Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
EBK JAVA PROGRAMMING
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT