Learning SQL Tutorial - Part 10 -- Where Clause -- Answers to Homework | Essential SQL

http://www.essentialsql.com/get-ready-to-learn-sql-3-how-to-filter-your-query-results Use the Where Clause to filter your search results. In this video we answer the following homework questions: --Select OrderID, OrderDate, and FreightCharge for all Orders whose freight charges are less than $10.00 --Select OrderID, OrderDate, and FreightCharges for all Orders whose freight charges are within the $4.00 to $7.00 range --Find all employees whose first name is "James" --Find all productIDs from these orders 1, 4, 10, 11