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. Views and their updatability.
g. Schema change commands.