/*AVG() is an aggregate function that returns the average value for a numeric column*/ SELECT AVG(column_name) FROM table_name;
/* COUNT() is a function that takes on the name of a clomn as an argument and counts the number of rows where the column is not null */ SELECT COUNT(column_name) FROM table_name;