Listing 4: Sales.SalesOrderHeader Query with Multiple Search Conditions

SELECT * FROM Sales.SalesOrderHeader
WHERE SalesPersonID = 278
AND CustomerID < 33