???? ???? Write the SQL statements and specify which will be selected. record id’s QUERY SQL Which records will be selected? RecordID All the toys ordered between SELECT July 1 and July 7 FROM WHERE Any toys with a wholesale cost SELECT more than $4.99 that were not FROM ordered by J. Mathers WHERE All the Brown toys that retail for SELECT more than $10.00 FROM WHERE Any toys that were ordered by T. SELECT Livingston or A. Hayes before FROM 7/1/2015 WHERE Any purple toys that retail for SELECT less than $5.00 or any green FROM toys that the store has fewer WHERE than 10 in stock
???? ???? Write the SQL statements and specify which record id’s will be selected. QUERY SQL Which records will be selected? RecordID All the toys ordered between July 1 and July 7 SELECT FROM WHERE Any toys with a wholesale cost more than $4.99 that were not ordered by J. Mathers SELECT FROM WHERE All the Brown toys that retail for more than $10.00 SELECT FROM WHERE Any toys that were ordered by T. Livingston or A. Hayes before 7/1/2015 SELECT FROM WHERE Any purple toys that retail for less than $5.00 or any green toys that the store has fewer than 10 in stock SELECT FROM WHERE