Discuss how each of the following constructs is used in SQL, and

Discuss how each of the following constructs is used in SQL, and discuss the various options for each construct. Specify what each construct is useful for.

a. Nested queries

b. Joined tables and outer joins

c. Aggregate functions and grouping

d. Triggers

e. Assertions and how they differ from triggers

f. The SQL WITH clause

g. SQL CASE construct

h. Views and their updatability

i. Schema change commands