A SQL statement in a content repository query is composed of a SELECT clause optionally followed by up to three more clauses: a FROM clause, a WHERE clause and an ORDER BY clause.