7.1: Describe the six clauses in the syntax of an SQL retrieval query. Show what type ofconstructs can be specified in each of the six clauses. Which of the six clauses arerequired and which are optional?7.2: Describe conceptually how an SQL retrieval query will be executed by specifyingthe conceptual order of executing each of the six clauses.7.3: Discuss how NULLs are treated in comparison operators in SQL. How are NULLstreated when aggregate functions are applied in SQL query? How are NULLS t

SQL PARTITION BY Clause overview

SQL examples for beginners: SQL SELECT statement usage