get same results but error in code. SUBSTR(first_name,1,1)
The question asks me to create a report from the customers table that shows their first initial of their first name and alias it as initial. Select their last name too. when I do so I get the same results but however, it shows an error.
My code: SELECT SUBSTR(first_name,1,1)|| " " || last_name as "initial" from customers
KRIS NIKOLAISEN52,653 Points
I'm not sure I understand the error message
Expecting results like 'L Chalkley' not 'L Chalkley'.
because it makes it seem like the columns should be concatenated. But for this challenge the columns are separate. And the alias only applies to the first initial of the first name.