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.
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