For EJB 2.1 EJB-QL has been enhanced with:
Addition of ORDER BY clause
Addition of Aggregate Functions AVG, MIN, MAX, SUM, COUNT to SELECT clause
Addition of MOD Function to WHERE clause
Clarification of requirements for returning null values from queries and finder and select methods
