sql can you get a count and sql code example

Example: sql count(*)

SELECT COUNT(column_name)
FROM table_name
WHERE condition;