8.1. Introduction8.1.1. Terminology8.1.2. Example Data Model8.1.3. Example Application8.2. Select Queries8.2.1. SELECT Clause8.2.1.1. Path Expressions8.2.1.2. Entities and Objects8.2.1.3. Combining Expressions8.2.1.4. Constructor Expressions8.2.1.5. Inheritance and Polymorphism8.2.2. FROM Clause8.2.2.1. Identification Variables8.2.2.2. Joins8.2.2.2.1. Inner Joins8.2.2.2.2. JOIN Operator and Collection Association Fields8.2.2.2.3. JOIN Operator and Single-Valued Association Fields8.2.2.2.4. Join Conditions in the WHERE Clause8.2.2.2.5. Multiple Joins8.2.2.2.6. Map Joins8.2.2.2.7. Outer Joins8.2.2.2.8. Fetch Joins8.2.3. WHERE Clause8.2.3.1. Input Parameters8.2.3.2. Basic Expression Form8.2.3.3. BETWEEN Expressions8.2.3.4. LIKE Expressions8.2.3.5. Subqueries8.2.3.6. IN Expressions8.2.3.7. Collection Expressions8.2.3.8. EXISTS Expressions8.2.3.9. ANY, ALL, and SOME Expressions8.2.4. Scalar Expressions8.2.4.1. Literals8.2.4.2. Function Expressions8.2.4.3. CASE Expressions8.2.5. ORDER BY Clause8.3. Aggregate Queries8.3.1. Aggregate Functions8.3.1.1. AVG8.3.1.2. COUNT8.3.1.3. MAX8.3.1.4. MIN8.3.1.5. SUM8.3.2. GROUP BY Clause8.3.3. HAVING Clause8.4. Update Queries8.5. Delete Queries8.6. Summary