SELECT SalesOrderID, ShipDate
FROM Sales.SalesOrderHeader
WHERE OrderDate BETWEEN '2002-07-28' AND '2014-07-29';

SELECT ProductID, Name
FROM Production.Product
WHERE StandardCost < 110.00;

SELECT ProductID, Name
FROM Production.Product
WHERE Weight IS NULL;

SELECT ProductID, Name, Color
FROM Production.Product
WHERE Color IN ('Silver', 'Black', 'Red');

SELECT ProductID, Name
FROM Production.Product
WHERE Name LIKE 'B%';

UPDATE Production.ProductDescription
SET Description = 'Chromoly steel_High of defects'
WHERE ProductDescriptionID = 3;

SELECT Description
FROM Production.ProductDescription
WHERE ProductDescriptionID = 3;

SELECT OrderDate, SUM(TotalDue) AS "Sum of TotalDue"
FROM Sales.SalesOrderHeader
WHERE OrderDate BETWEEN '2001-07-01' AND '2014-07-31'
GROUP BY OrderDate
ORDER BY OrderDate;

SELECT DISTINCT HireDate
FROM HumanResources.Employee;

SELECT AVG(DISTINCT ListPrice) AS "Average of Unique List Prices"
FROM Production.Product;

SELECT
    CONCAT('The ', Name, ' is only! ', ListPrice) AS "Product Details"
FROM Production.Product
WHERE ListPrice BETWEEN 100 AND 120
ORDER BY ListPrice;
SELECT
    rowguid,
    Name,
    SalesPersonID,
    Demographics
INTO
    Store_Archive
FROM
    Sales.Store;

