The query shown below has one or more errors. In the space below:

identify the type of error displayed by the query

specifically identify what is the cause of the error

articulate $($i$.$e$.,$ use words$)$ how to fix the error

In all cases: be specific! The more specific the answer, the more points will be earned.

$$SELECT VendorID,

VendorName,

VendorContactFName $++++$ VendorContactLName as ContactName

FROM Vendors

WHERE VendorID NOT INA

$()$il

SELECT InvoI$$CeID

FROM Invoices

$100\%$

Results

Messages

$\backslash$table$[[,$VendorlD,VendorName,ContactName$],[1,115,$Roadway Package System, Inc,Sam Smith$],[2,116,$State of Calfomia,Mercedez Articunia$],[3,117,$Suburban Propane,Harold Spivak$],[4,118,$Unocal,Rachael Bluzinski$],[5,119,$Yesmed, Inc,Reba Hemandez$],[6,120,$Datafoms $\frac{?}{?}$ West,Charlie Church$]]$