Question
Produce a list of the cities in the customer table where each city is listed once and the list is sorted. Send the list to
Produce a list of the cities in the customer table where each city is listed once and the list is sorted. Send the list to a table name List of Cities. Please help me write the correct SQL syntax for the above instructions regarding the below data.
| CustomerID | First Name | Last Name | Address | City | Phone Number |
| C0001 | Eileen | Faulkner | 2732 Baker Blvd. | Toronto | (647) 334-5678 |
| C0002 | Scott | Wit | 120 Hanover Sq. | Ottawa | (613) 358-3364 |
| C0003 | Benjamin | Grauer | 1007 W. Main St | Toronto | (647) 998-4457 |
| C0004 | Wendy | Solomon | 12 Orchestra Terrace | Kitchener | (519) 447-2283 |
| C0005 | Alex | Rey | P.O. Box 555 | Toronto | (647) 988-3346 |
| C0006 | Ted | Myerson | 2743 Bering St. | Ottawa | (613) 447-5565 |
| C0007 | Lori | Sangastiano | 2743 Bering St. | Toronto | (647) 775-3389 |
| C0008 | Michelle | Zacco | 89 Jefferson Way | Kitchener | (519) 258-7655 |
| C0009 | David | Powell | 187 Suffolk Ln. | Toronto | (647) 998-5557 |
| C0010 | Matt | Hirsch | 305 - 14th Ave. S. | Kitchener | (519) 334-6654 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Oracle Database Foundations Technology Fundamentals For IT Success
Authors: Bob Bryla
1st Edition
0782143725, 9780782143720
