Databases Reporting with SQL Working with Text Changing Cases of Strings

Reporting with SQL Challenge Task

When I type in the following, it keeps telling me that it is not returning all the books in lowercase and authors in uppercase. I can't figure out what I am doing wrong.

SELECT LOWER (title), UPPER (author) AS "lowercase_title", "uppercase_author" FROM books;

2 Answers

Steven Parker
Steven Parker
168,395 Points

The aliases must be applied to each column individually:

SELECT LOWER(title) AS "lowercase_title", UPPER(author) AS "uppercase_author" FROM books;

Thank You!!!!!