Question: Write a SELECT statement that returns one column from the Customers table named full_name that joins the last_name and first_name columns. Format this column
Write a SELECT statement that returns one column from the Customers table named full_name that joins the last_name and first_name columns. Format this column with the last name, a comma, a space, and the first name like this: Doe, John Sort the result set by the last_name column in ascending sequence. Return only the customers whose last name begins with letters from M to Z. NOTE: When comparing strings of characters, 'M' comes before any string of characters that begins with 'M'. For example, 'M' comes before 'Murach'.
Step by Step Solution
3.32 Rating (149 Votes )
There are 3 Steps involved in it
You can achieve this with a SQL SELECT statement like this sql SELECT CONCATlastname firstnam... View full answer
Get step-by-step solutions from verified subject matter experts
