Could you fix this for me, please?

--Q4-Write an INSERT statement that adds a row to the VendorCopy table for each non-California vendor in the Vendors table. --(This will result in duplicate vendors in the VendorCopy table.) INSERT into Vendorcopy (VendorID, VendorName, VendorAddress1, VendorAddress2, VendorCity, VendorState, VendorZipCode, VendorPhone, VendorContactLName, VendorContactFName, DefaultTermsID, DefaultAccountNo) SELECT (VendorID 2 VendorName, VendorAddress1, VendorAddress2, VendorCity, VendorState, VendorZipCode, VendorPhone, VendorContactLName, VendorContactFName, DefaultTermsID, DefaultAccountNo) FROM Vendors WHERE Vendorstate I=CA ' ; Msg 102, Level 15, State 1, Line 6 Incorrect syntax near','. Total execution time: 00:00:00