Shain Jones1,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.
SELECT first_name || " " || UPPER(last_name) AS Full_name, library_id FROM patrons;