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