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.

help with the sql code for all unique state cities
help with the sql code for all unique state cities - Write

- 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!