Using an Aggregate function in SAP HANA

You can use an aggregate function to get the same. Common aggregation functions are −

Average() − returns the average of the numeric values in a given column

Select Average (Sales) from table_name where Column1=’ABC’;