Databases Reporting with SQL Working with Text Changing Cases of Strings

Complex formula please help

Question - 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 answer: SELECT first_name || " " || last_name AS "full name" WITH UPPER(last_name), library_id FROM patrons;

This is incorrect, what have I done wrong... could someone explain please

1 Answer

Steven Parker
Steven Parker
168,518 Points

You're getting close, but the function to convert case needs to be used on "last_name" when it is first referenced. There's no syntax for modifying a select using the keyword "WITH".

Also, you aliased your constructed name as "full name" (with a space), but the instructions ask for "full_name" (with an underscore).