Enter and run your own SELECT statements, this is SQL Server 2012, my guitar sho

Question

Enter and run your own SELECT statements, this is SQL Server 2012, my guitar shop

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 letters from M to Z. Write a SELECT statement that returns these column names and data from the Products table: Return only the rows with a list price that's greater than 500 andless than 2000. Sort the result set in descending sequence by the DateAdded column.

Explanation / Answer

2)select LastName + ', ' + FirstName as FullName

from Customers

order by LastName ASC

3)select ProductName,ListPrice,DateAddedf

rom Products

where ListPrice between 500 and 2000

order by DateAdded DESC

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.