select avg(aggregate_expression) from table_name [where condition];
select avg(marks) as "Total Marks" from table2;
select avg(marks) as "Total Marks" from table2 where marks>65;
select avg(DISTINCT marks) as "Total Marks" from table2 where marks>60;