Abstract Schema NamesSimple QueriesSelecting Entity and Relationship PropertiesConstructor ExpressionsThe IN Operator and INNER JOINLEFT JOINFetch JoinsUsing DISTINCTThe WHERE Clause and LiteralsThe WHERE Clause and Operator PrecedenceThe WHERE Clause and Arithmetic OperatorsThe WHERE Clause and Logical OperatorsThe WHERE Clause and Comparison SymbolsThe WHERE Clause and Equality SemanticsThe WHERE Clause and BETWEENThe WHERE Clause and INThe WHERE Clause and IS NULLThe WHERE Clause and IS EMPTYThe WHERE Clause and MEMBER OFThe WHERE Clause and LIKEFunctional ExpressionsFunctional expressions in the WHERE clauseFunctions returning dates and timesAggregate functions in the SELECT clauseCOUNT (identifier or path expression)MAX( path expression), MIN( path expression)AVG( numeric ), SUM( numeric)DISTINCT, nulls, and empty argumentsThe ORDER BY ClauseBulk UPDATE and DELETE