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