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

DRAG DROP
You are developing a Microsoft Azure SQL Database instance to support a company’s payroll system. The database contains a table named Employee defined by the following Transact-SQL statement:

The company defines five employee levels. Each employee’s level is stored in the Level column. Levels 1,2, and 3 are used for non-executive employees. Levels 4 and 5 are used for executives. Each of the non-executive levels has a defined range that constrains the salary of employees at that level.
You need to create a view that allows non-executive Employees entries to be updated based on the following rules:
Only non-executive employees can be viewed or updated. Employees can be promoted to a non-executive level.
Employees cannot be promoted to an executive level.
If an employees’ salary changes, the new salary must adhere to the company-defined range for that level.
Which four 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:
Box 1: WITH SCHEMABINDING AS
The syntax is: CREATE VIEW
WITH SCHEMABINDING
AS
Box 2:
SELECT DISTINCT cannot be used here.
Box 3: ORDER BY
Box 4:
Create a clustered index.
References: https://docs.microsoft.com/en-us/sql/relational-databases/views/create-indexed-views?view=sql-server-2017