COUNT SELECT COUNT(column_name) FROM table_name WHERE condition; Returns number of rows that match the condition SELECT COUNT(dep_id) FROM employees; AVG SELECT AVG(column_name) FROM table_name WHERE ...

HAVING SELECT column_name, COUNT() FROM table_name GROUP BY column_name HAVING COUNT() > value; HAVING was added to SQL because the WHERE keyword could not be used with aggregate functions. INNER JOIN ...