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 ...

Download this SQL Interview Cheat Sheet, and use it as a reference for your next SQL interview. What's inside the SQL Cheat Sheet? 1. SQL Basics: Quick refreshers on SELECT, WHERE, and JOINs.

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 ...