Description

---

You recently added feedback functionality to the small web service you own. You were able to handle everything manually at first, but the amount of messages you receive now is overwhelming. As such, you’ve decided to start generating generic responses automatically.

All customer names are stored in the table customers with the following structure:

• id: unique customer id;
• name: the name of the customer in the format described below.

The customer’s name is stored in the following format: \<first name\> \<last name\> (two words separated by single space), where first and last names can contain both uppercase and lowercase English letters.

Your task is to write a function that, given the customer’s name, will return the following message:

Dear ! We received your message and will process it as soon as possible. Thanks for using our service. FooBar On! - FooBarIO team. </code>

Here, \<Firstname\> and \<Lastname\> are the first and the last names of the customer, with the first letter in uppercase and with all other letters in lowercase.

Example

For the following tables customers

id	name
1	JOHN GaLT
2	SANDY COHEN

the output should be

id	name	response
1	JOHN GaLT	Dear John Galt! We received your message and will process it as soon as possible. Thanks for using our service. FooBar On! - FooBarIO team.
2	SANDY COHEN	Dear Sandy Cohen! We received your message and will process it as soon as possible. Thanks for using our service. FooBar On! - FooBarIO team.

• [execution time limit] 10 seconds (mysql)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
DROP FUNCTION IF EXISTS response;
CREATE FUNCTION response(name VARCHAR(40)) RETURNS VARCHAR(200) DETERMINISTIC
BEGIN
    SET @firstName = CONCAT(SUBSTRING_INDEX(LOWER(name), ' ', 1));
    SET @secondName = CONCAT(SUBSTRING_INDEX(LOWER(name), ' ', -1));
    
    RETURN CONCAT('Dear ',UPPER(LEFT(@firstName,1)), MID(@firstName,2) ,' ',
                UPPER(LEFT(@secondName,1)), MID(@secondName,2),'! We received your message and will process it as soon as possible. Thanks for using our service. FooBar On! - FooBarIO team.');
END;

CREATE PROCEDURE customerMessages()
BEGIN
    SELECT id, name, response(name) AS response
    FROM customers;
END;