//NUMBER 1
SELECT  ProductCode   AS code,
        ProductName   AS name,
        ListPrice     AS price,
        DiscountPrice
FROM tblProducts
ORDER BY price;

//NUMBER 2
SELECT  CONCAT(LastName, ',', FirstName) AS FullName
FROM Customers
WHERE FullName >= 'm'
ORDER BY FullName;

//NUMBER 3
SELECT ProductName AS Name,
        ListPrice AS Price,
        DateAdded AS DateAdded
FROM tblProducts
WHERE Price > 500 AND Price < 2000
ORDER BY DateAdded