This statement is ANSI SQL:2011 compliant. AVERAGE and AVE are Teradata extensions to the ANSI standard.