The following are some of the more advanced SQL commands including: Aggregate Functions, Conditional Operators, Mathematical Operators and Table Joins. Some of the criteria is specific to ColdFusion development