//1
SELECT BusinessEntityID,PersonType,FirstName,LastName
FROM Person.Person;
//2
SELECT FirstName,LastName
FROM Person.Person
WHERE FirstName ='Adam'
ORDER BY LastName ASC;
//3
SELECT ProductID, Name, ProductNumber, ListPrice
FROM Production.Product
WHERE Color ='Red'
ORDER BY ListPrice DESC;
//4
SELECT ProductID, Name, ProductNumber, ListPrice, Size
FROM Production.Product
WHERE Size ='M';
//5
SELECT BusinessEntityID,Name,SalesPersonID
FROM Sales.Store
WHERE SalesPersonID IN (275,276,277);
//6
SELECT *
FROM Sales.SalesOrderDetail
WHERE SalesOrderID BETWEEN 69000 AND 70000;
//7
SELECT *
FROM HumanResources.Employee
WHERE JobTitle LIKE '% Specialist';
//8
SELECT *
FROM Purchasing.Vendor
WHERE PurchasingWebServiceURL IS NOT NULL;
//9
SELECT *
FROM Production.Product
WHERE Class IS NULL;
//10
SELECT *
FROM Sales.SalesOrderHeader
WHERE (
TerritoryID = 9
AND
Year(OrderDate) = 2014
);