You need to create the Store Sales database using the scripts under the Course Resources. Using the Store Sales database, create a mailing list from the CUSTOMERS table. The mailing list should display the name, address, city, stat and zip code for each customer. Look at the attached sample output and match your results. Name Location Zip John Brown 123 Main Street Charlotte, NC 28226 Cynthia Green 345 Salem Drive Waxhaw, NC 28173 Steve White 6006 Bollar Court Charlotte, NC 28277 Gail Black 4000 Woodfox Road Monroe, NC 28110 28226 80119 Doreen Blue 5677 Seth Drive Charlotte, NC Sean Egen 1290 Zenby Drive Denver, co 6 rowa selected
You need to create the Store Sales database using the scripts under the Course Resources. Using the Store Sales database, create a mailing list from the CUSTOMERS table. The mailing list should display the name, address, city, stat and zip code for each customer. Look at the attached sample output and match your results. Name Location Zip John Brown 123 Main Street Charlotte, NC 28226 Cynthia Green 345 Salem Drive Waxhaw, NC 28173 Steve White 6006 Bollar Court Charlotte, NC 28277 Gail Black 4000 Woodfox Road Monroe, NC 28110 28226 80119 Doreen Blue 5677 Seth Drive Charlotte, NC Sean Egen 1290 Zenby Drive Denver, co 6 rowa selected
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question

Transcribed Image Text:### Creating a Mailing List from the Store Sales Database
To create a mailing list using the Store Sales database, follow these steps:
1. **Database Setup:** Begin by creating the Store Sales database using the scripts provided in the Course Resources.
2. **Accessing the Data:** Focus on the CUSTOMERS table to retrieve the necessary information.
3. **Query Requirements:** Your goal is to display each customer's name, address, city, state, and zip code.
#### Sample Output
Here’s an example of the expected output after running the appropriate query:
| Name | Location | Zip |
|--------------|--------------------------------------|-------|
| John Brown | 123 Main Street Charlotte, NC | 28226 |
| Cynthia Green| 345 Salem Drive Waxhaw, NC | 28173 |
| Steve White | 6006 Bollar Court Charlotte, NC | 28277 |
| Gail Black | 4000 Woodfox Road Monroe, NC | 28110 |
| Doreen Blue | 5677 Seth Drive Charlotte, NC | 28226 |
| Sean Egen | 1290 Zenby Drive Denver, CO | 80119 |
*Note: 6 rows have been selected for the sample mailing list.*
#### Constructing the Query
Your query should effectively extract the data to match the format of this sample output, focusing on the specified columns from the database.
Each row in the output includes:
- **Name:** The customer's full name.
- **Location:** A concatenation of the street address, city, and state.
- **Zip:** The postal code corresponding to the customer's address.
By accurately constructing your query, you can ensure that your results align with the provided sample, thus verifying the successful setup and access of the Store Sales database.
Expert Solution

Step 1
Step by step
Solved in 2 steps with 4 images

Knowledge Booster
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.Recommended textbooks for you

Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON

Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education