Question: Implementation in MySQL language Please Submit As soon as possible A company wants to contact each of its customers regarding the policy changes. They have

 Implementation in MySQL language Please Submit As soon as possible A

company wants to contact each of its customers regarding the policy changes.

They have international customers, but their database does not include country codes

Implementation in MySQL language

Please Submit As soon as possible

A company wants to contact each of its customers regarding the policy changes. They have international customers, but their database does not include country codes with their phone numbers. There are two tables in the database: customers and country_codes. The first table contains details of every customer including customer_id, name, phone number, and country. The second table contains the country code for every country. Write a query to retrieve a list of all customer ids, names, and phone numbers, with their country codes concatenated with their phone numbers. Sort the output in the order of their customer_id. Note: The phone number should be in the following format: +COUNTRY_CODE PHONENUMBER (without spaces) Schema There are 2 tables: customers, country_codes. customers Name Type Description customer_id INTEGER This is the unique customer id. It is the primary key. name STRING The name of the customers having [1, 20] characters. phone_number STRING The phone number of the customer having [6,13] characters. country STRING The country of the customer. It is a foreign key taken from country_codes country codes Name Type Description country STRING The name of the country. It is the primary key. country_code STRING The country code of this country. Sample Data Tables customers customer_id name phone_number country 1 Raghav 951341341 India 2. Jake 52341351 USA 3 Alice 61341351 USA country_codes country country_code USA 1 India 91 Sample Output 1 Raghav +91951341341 2 Jake +152341351 3 Alice +161341351 Explanation: Since Raghav is from India, the country code is 91, so the complete phone number is +91951341341 Since Jake is from the USA, the country code is 1, and the complete phone number is +152341351 Since Alice is from the USA, the country code is 1, and the complete phone number is +161341351

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!