@Test
public void shouldBeAbleToCreateAndExecuteJcrSql2QueryToFindAllCarNodesOrderedByYear() throws RepositoryException {

    String sql = "SELECT * FROM [car:Car] ORDER BY [car:year]";
    Query query = session.getWorkspace().getQueryManager().createQuery(sql, Query.JCR_SQL2);
    QueryResult result = query.execute();
    validateQuery().rowCount(13).hasColumns(carColumnNames("car:Car")).validate(query, result);
}