Databases Reporting with SQL Working with Text Changing Cases of Strings

Orchid Li
Orchid Li
1,866 Points

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

Select upper(last_time) || " " || first_name as "full_name", library_id from patrons;

Not sure what is wrong with this? Thanks, Orchid

2 Answers

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 50,936 Points

You have two issues

1) You have column last_time instead of last_name

2) first_name goes before last_name in full_name

Orchid Li
Orchid Li
1,866 Points

Thanks, Orchid