I could use some assistance. Thank you

1. In your WHERE statement, anytime you use the wildcard % you should use the word LIKE instead of -. For example: WHERE Firstname LIKE 'BA%' instead of WHERE Firstname = 'BA%' True False 2. Which is the syntax for running a query that EXCLUDES rows. A Where not ReorderPoint = 1000 B Where ReorderPoint not = 1000 C Where ReorderPoint no = 1000 No Where ReorderPoint = 1000 3. What is the syntax for a WHERE statement that excludes the persontype values of EM, SP, SC and VC? Select TWO answers. A WHERE not persontype = ('EM''SP'SC,VC") 6 WHERE not persontype in ('EM','SPSC''VC") WHERE persontype not = ('EM''SP,'SCVC") WHERE persontype not in ('EM'SP'SC,VC') 4. Parenthetical search conditions are processed before non-parenthetical search conditions. Example: SELECT * FROM Staff WHERE (StfAreaCode = '425' and StfPhone Number LIKE '555%') OR Date Hired BETWEEN '2007-10-01' and '2007-12-31 True F False 5. Which statement helps your database process this query faster? A Select Custnbr, Name, Address1, City, State, AmtDue from Customer where State = 'FL' AND AmtDue > 5000 Select Custnbr, Name, Address1, City, State from Customer where AmtDue > 5000 AND State = 'FL It doesn't matter, virtually all commercial databases systems include a query optimizer. 6. When creating a WHERE statement looking for a NULL value, the syntax is: WHERE MiddleName = NULL True F False 7. Which two queries would answer the question "Show me the name of every student that started college in January 2016" Select TWO answers. Select firstname, lastname from student where startdate between '2016-01-01' and '2016-01- 31 B Select firstname, lastname from student where startdate '2016- 01-31 Select firstname, lastname from student where startdate > '2016-01-01' and startdate = '2016-01-01 and startdate