The mailing system needs customer full names in a single field. Combine the first and last name columns into one "Full Name" field.
Write a SQL query that concatenates FirstName and LastName with a space between them. Return this along with the customer's email.
| Column | Type |
|---|---|
| CustomerId | INTEGER (Primary Key) |
| FirstName | TEXT |
| LastName | TEXT |
| Company | TEXT |
| Address | TEXT |
| City | TEXT |
| State | TEXT |
| Country | TEXT |
| PostalCode | TEXT |
| Phone | TEXT |
| Fax | TEXT |
| TEXT | |
| SupportRepId | INTEGER (Foreign Key → Employee.EmployeeId) |
Use || to concatenate strings: 'Hello' || ' ' || 'World' = 'Hello World'
Ready to take your skills to the next level? Enroll in our comprehensive Data Analyst Career Track to master SQL, Python, Excel, and Power BI.
Run your code to see the result here.