Use the UNION operator to generate a result set consisting o…

Use the UNION operator to generate a result set consisting of two columns from the Vendors table: VendorName and VendorState. Which statement returns the rows for both VendorState = ‘CA’  and VendorState = ‘TX’? A.  SELECT VendorName, VendorState  FROM Vendors  WHERE VendorState = ‘CA’UNION SELECT VendorName, VendorState, ZendorZipCode  FROM Vendors WHERE VendorState ‘TX’;B. SELECT VendorName, VendorState FROM Vendors WHERE VendorState = ‘CA’ UNION SELECT VendorName, VendorState FROM Vendors WHERE VendorState = ‘TX’;