Which four T-SQL statements should you use?

You use a Microsoft SQL Server 2012 database. You need to create an indexed view within the database for a
report that displays Customer Name and the total revenue for that customer. Which four T-SQL statements
should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer
area and arrange them in the correct order.)

Answer:

Explanation:

Reference: http://msdn.microsoft.com/en-us/library/ms191432.aspx