Databases Reporting with SQL Working with Text Changing Cases of Strings

David Wells
David Wells
13,270 Points

In the second question of the library/full name question, how do I write the concatenation SQL statement?

In this problem, I'm being asked to query two columns from a table, the first being concatenated from two columns of text. In this question, I have concatenated using all three forms of code provided earlier. Here are the other two:

SELECT first_name || ' ' || UPPER(last_name) AS full_name, library_id FROM patrons

SELECT CONCAT(first_name, " ", UPPER(last_name)) AS full_name, library_id FROM patrons

I cannot for the life of me figure out what I'm doing wrong, as the quiz only tells me "there's something wrong with your SQL code." What am I doing wrong?

2 Answers

Steven Parker
Steven Parker
203,115 Points

Your code looks fine to me, so I tested it pasting it directly into the challenge and it passed.

Give it another try, and if you still have trouble try restarting your browser.