Question: help with the sql code for all unique state cities - Write a query to determine what states the customers in the database are from.
- Write a query to determine what states the customers in the database are from. SAVE THIS QUERY IN THE DATABASE AS "07_ALL_UNIQUE_STATES" - Now, what if there were two cities with the same name in different states: e.g. Scranton, NJ and Scranton, PA? Modify one of the customer records in your database to create such a scenario. Then, write a query which finds what cities the customers in the database are from, and is able to distinguish between cities with the same name in different states. SAVE THIS QUERY IN THE DATABASE AS "08_ALL_UNIQUE_STATE_CITIES" lames Russell. Data and database design by Jacob Zahavi \& Nissan Levin. Introduction to SQL Page 5
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
