Summer Lewis

Use AND, OR and comparison operators in WHERE

Task 2

  • November 3, 2016 at 10:08 AM
  • Last updated about 9 years ago
  • Visible to public
I have all of my queries listed here, grouped by task:
https://drive.google.com/open?id=0B5hBlRd1P7vEbXF6azltbXBHU0E
  1. select * From Orders where DateOrdered='2016-05-01 08:43:07' or DateOrdered='2016-05-01 09:02:43'
  2. select * From Products where CaseQuantity=2 or NumberInStock<5
  3. select * From Customers where CustomerID='CuSto1234' and LastName='Stove'
  4. select * From Customers where (FirstName='Franken' and LastName='Otter') or Email='Derivingfromstuff@aol.com'