Databases Reporting with SQL Working with Text Creating Excerpts

Namazbek Bekarysuly
Namazbek Bekarysuly
882 Points

What is wrong?

SELECT SUBSTR(first_name, 1, 1) || ' ' || last_name AS initial FROM customers;

1 Answer

Steven Parker
Steven Parker
155,695 Points

When they said "Select their last name too.", they meant select it as a separate column. You won't need to do any concatenation for this one.