Databases Reporting with SQL Working with Text Changing Cases of Strings

Shain Jones
Shain Jones
1,151 Points

Reporting with SQL

I have attempted to change the syntax around, but I have been unable thus far to get to the answer that they are wanting from me. Any guidance would be greatly appreciated.

Thanks in advance.


In the library database there's a patrons table with the columns id, first_name, last_name, address, email, library_id, and zip_code.

The library is generating new library cards that will display the full name and their library ID. The full name needs to have the last name in all caps. Create a report with two columns of results, one is an alias of full_name the second being the library_id.

My response:

SELECT first_name || " " || UPPER(last_name) AS Full_name, library_id FROM patrons;

1 Answer

Pro Student 43,535 Points

The alias for full name is lowercase full_name.