MySQL

Question

here's the question:

Select the first letter of the "first_name", followed by a period, followed by a space and then add the "last_name". Also, convert "last_name" to upper case. Alias it as "name". Here's an example: "A. CHALKLEY". The name of the table is "users".

here's my latest failed answer:

select concat(substring(upper(first_name,"."," "),1, 1))), (upper(last_name)) as name from users;

any suggestions would be appreciated

Answer 1 · 2016-02-26T02:59:10Z

February 26, 2016 2:59am

Hey Bill,

You didn't link to the challenge, so I can't test this query to see if it works. For future reference, it's always best to click the "Need Help / Get Help" link on the page of the quiz / challenge / video where you are working, as this will link to exactly where you are. I also added markdown to your question to make the code more readable.

However, it seems like you have a small issue with the parenthesis and I don't believe the challenge is asking you to uppercase the first name call.

SELECT CONCAT(SUBSTRING(first_name, 1, 1), ". ", UPPER(last_name)) AS name FROM users;

and instead of doing the period and space in two separate quotes, I would just use one.

Give that a shot and see if it works.

Answer 2 · 2016-02-26T02:52:56Z

February 26, 2016 2:52am

You got your parenthesis in a bind, which is altering the outcome. Should be:

SELECT CONCAT(SUBSTRING(UPPER(first_name),1,1),". ",UPPER(last_name)) AS name FROM users;

Welcome to the Treehouse Community

Looking to learn something new?

Bill Ertle

Bill Ertle

MySQL

2 Answers

Jason Anders

Jason Anders

Bill Ertle

Bill Ertle

Andrew Winkler

Andrew Winkler

Andrew Winkler

Andrew Winkler

Bill Ertle

Bill Ertle