Which three Transact-SQL segments should you use to develop the solution?

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.
Select and Place:

Correct Answer:

Explanation/Reference:
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-transact-sql?view=sql-server-2017