Getting the right result, but program doesn't approve it.
So in the substr task this query doesn't work for some reason
SELECT SUBSTR(first_name, 1, 1) || " " || last_name AS initial FROM customers
im gettin an error which says: Expecting results like 'L Chalkley' not 'L Chalkley'.
and as far as i see, that 2 results are the same.
KRIS NIKOLAISENPro Student 43,382 Points
The error message is misleading. According to the instructions you are to alias the first initial and select the last name. Like this:
SELECT SUBSTR(first_name, 1, 1) as initial, last_name FROM customers
yep, that's it thanks