You can code views that ?

(a) join tables

(b) summarize data

(c)use subqueries and functions

(d) all of the above

The SELECT statement for a view:

(a) cant use an ORDER BY clause

(b) can include the INTO keyword

(c)can use the ORDER BY clause if it also uses the TOP clause

(d)cannot use the ORDER BY clause with the OFFSET and FETCH clauses

By default, (A)columns from different tables with the same name do not have to be renamed (B)columns in a view are given the same names as the columns in the base tables (C)calculated columns do not need to be named in the SELECT statement (D) all of the above