Changing the cases of strings: Code Challenge 2 SQL

I figured it out, thank you! SELECT first_name ||' '|| UPPER(last_name) AS "full_name", library_id FROM patrons;

Think from the end:

The library is generating new library cards that will display the full name and their library ID.

You need to have SQL table somewhat like this:

full_name       |  library_id
----------------|-------------|
Andrew Chalkey  | MCL1001

So first of all you need to write something like this:

SELECT ... AS full_name, library_id FROM patrons

Now think what to put in ....

Full name is "first_name" + "last_name".

But also last_name has to be in CAPS,because of

The full name needs to have the last name in all caps

So

"first_name" + "UPPER(last_name)"

Then we also probably should put space between first and last_name, otherwise it will be strange full_name, right?

"first_name" + " " + "UPPER(last_name)"

All that is left is to connect them using proper LOGICAL operator and put everything into ... specified above and write final query.

Tried my best to give you hints:) Hope it was helpful.

The double quotes work also. SELECT first_name || " " || UPPER(last_name) AS full_name, library_id FROM patrons;

It's because you have LOWER(first_name). It forces the entire name to be lower case.

Building on the concatenation knowledge from the former challenge is the key here.

This chapter's challenges is really testing my patience.