You have an Azure SQL database that contains tables for customers and orders. You need to create a query that will return the orders placed by each customer. Which two Transact-SOL statements should…

INDEX is a database object created with CREATE INDEX, not a query clause; it cannot appear inside a SELECT statement to filter or join data.

EXISTS is a subquery predicate used to test for the presence of rows, not to join two tables and return combined columns from both.

JOIN combines rows from the customers table and the orders table based on a shared key, which is required to associate each order with its customer.

ORDER BY sequences the result set - typically by customer identifier - so that orders grouped under each customer are returned in a meaningful, organized order.

While SELECT is required in any query, it alone does not establish the relationship between the customers and orders tables; the question asks for the two statements that specifically address joining and organizing the data.