Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //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 DECS
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement