SELECT SUM(column_name) FROM table_name WHERE condition;
SELECT COUNT(column_name) FROM table_name WHERE condition;
/* 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;
SELECT AVG(column_name) FROM table_name WHERE condition;