DRAG DROP
You develop a database application for Microsoft SQL Server 2012 and Microsoft Azure SQL Database.
You create a table named Purchasing.vVendorWithAddresses as shown in the following table.
You write the following Transact-SQL (Line numbers are included for reference only.) 01 CREATE PROCEDURE
You need to add Transact-SQL statements at line 08 to ensure that GetVendorInStateNeighbors returns the names of vendors that are located in all states where the vendor specified in the @vendorname parameter has a location.
Which three Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.
Answer: 
Explanation:
The IN statement determines whether a specified value matches any value in a subquery or a list.
Incorrect: The EXISTS command specifies a subquery to test for the existence of rows.
References: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/in-transactsql?view=sql-server-2017