The schema for the Ch07_LargeCo database is shown below. Click this image to view it in its own tab.

This figure is for visual aide and may not match the database schema exactly.

The Ch07_LargeCo database stores data for a company that sells paint products. The company tracks the sale of products to customers. The database keeps data on customers (LGCUSTOMER), sales (LGINVOICE), products (LGPRODUCT), which products are on which invoices (LGLINE), employees (LGEMPLOYEE), the salary history of each employee (LGSALARY_HISTORY), departments (LGDEPARTMENT), product brands (LGBRAND), vendors (LGVENDOR), and which vendors supply each product (LGSUPPLIES). Some of the tables contain only a few rows of data, while other tables are quite large; for example, there are only eight departments, but more than 3,300 invoices containing over 11,000 invoice lines. For Problems 2855, a figure of the correct output for each problem is provided. If the output of the query is very large, only the first several rows of the output are shown.

Question 32:

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 2017-7-15, and 2017-7-31. If a customer purchased more than one such product, display the customers information only once in the output. Sort the output by state, last name, and then first name (Partial results shown in Figure P7.32):

TAKE SPECIAL ATTENTION TO THE CAPITALS IN EVERY WORD PLEASE

FIGURE P7.27 THE CHOZ_LARGECO ERD LGCUSTOMER PK Cust Code LGBRAND PK Brand ID Brand_Name Brand_Type Cust_Fname Cust_Lname Cust_Street Cust_City Cust_State Cust_ZIP Cust_Balance includes plates LGPRODUCT LGLINE PK Prod SKU LGINVOICE PK Inv Num PK,FK1 Inv_Num | Line Num # contains appears on + FK2 FK1 Cust_code Inv_Date Inv_Total FK2 Employee_ID Prod_SKU Line_Qty Line Price Prod_Descript Prod Type Prod Base Prod_Category Prod_Price Prod_QOH Prod Min FK1 Brand_ID completes provided by LGEMPLOYEE PK Emp Num LGSALARY HISTORY LGSUPPLIES has PK,FK1 Emp Num PK Sal From # PK,FK1 Vend ID PK,FK2 Prod SKU Emp_Fname Emp_Lname Emp_Email Emp_Phone Emp_Hiredate Emp_Title Emp_Comm FK1 Dept_Num Sal End Sal_Amount provides manages employs I 70 LGVENDOR PK Vend ID LGDEPARTMENT PK Dept_Num Vend_Name Vend_Street Vend_City Vend_State Vend_ZIP Dept_Name Dept_Mail_Box Dept_Phone FK1 Emp_Num CUST_FNAME CUST_LNAME CUST_STREET CUST_CITY CUST_STATE CUST_ZIP LUPE SANTANA 1292 WEST 70TH PLACE Phenix City AL 36867 HOLLIS STILES 1493 DOLLY MADISON CIRCLE Snow Hill AL 36778 LISETTE WHITTAKER 339 NORTHPARK DRIVE Montgomery AL 36197 DEANDRE JAMISON 1571 HANES STREET Miami FL 33169 CATHLEEN WHITMAN 1712 NORTHFIELD DRIVE Marshallville GA 31057 SHERIE STOVER 640 MOUNTAIN VIEW DRIVE Parksville KY 40464 BRYCE HOGAN 1860 IMLACH DRIVE Newbury MA 01951 SHELBY SALAS 486 SUSITNA VIEW COURT North Tisbury MA 02568 JERMAINE HANCOCK 1627 SAUNDERS ROAD Ellicott City MD 21041 WHITNEY WHITFIELD 1259 RHONE STREET Phippsburg ME 04567