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.
Complex Queries,Triggers, Views, and Schema Modification 7.1. Describe the six clauses in the syntax of an SQL retrieval query. Show what type of constructs can be specified in each of the six clauses. Which of the six clauses are required and which are optional? 7.2. Describe conceptually how an SQL retrieval query will be executed […]