Question

WRITE A SQL QUERY SQL SERVER

Write a SELECT statement that returns one column from the Customers table named FullName that joins the LastName and FirstName 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 last name in ascending sequence.
--       Return only the contacts whose last name begins with a letter from M to Z.
--       4 points
--       I got 227 rows.
--       QUESTION: What is the FullName in record 4?
--       ANSWER:

Answer 1

select concat(Last_Name,', ', First_Name) as Fullname from Customers where Last_Name LIKE '[m-z]%' order by Last_Name asc;

Above is the sql query of your question