1) (3 points) The Murach AP schema contains a table called VENDORS. Use the CREATE TABLE AS syntax with the IN operator to create a table called VENDORS SUBSET that consists just of vendor name, state, and zip code (and no other attributes) for those vendors in the VENDOR table that are based in either California or Pennslyvania and have zip codes of less than 90024. 2) (2 points) Write an UPDATE statement with the IN operator to change all of the line item amount values in the INVOICE LINE ITEM table so that they are $3 more than the current amount for those line items that are NOT "Freight" or "Property Taxes". Be careful not to miss the "NOT 3) (2 points) Write a DELETE statement to remove all rows in the VENDOR CONTACT table that have last nams that either (a) start with either a "D" or end in a "S" and first names that begin with an "M" OR (b) contain the sequence "al" somewhere in the first name. Do not do (a) and (b) as separate queries. You should only have ONE query