The exchange part of the customer phone number



Refer to the tblCustomer table below. As a data analyst, you have been requested to select rows that meet the following requirements: For each city, list the city name in all upper case characters along with the exchange part of the customer phone number (the first 3 digits). Include only preferred customers in the list. Order the rows in alphabetical order of city. Be sure to give the calculated columns an alias.

Solution Preview :

Prepared by a verified Expert
Other Subject: The exchange part of the customer phone number
Reference No:- TGS0114247

Now Priced at $40 (50% Discount)

Recommended (95%)

Rated (4.7/5)