SELECT column_name, aggregate_function(column_name) FROM TABLE_NAME WHERE column_name operator VALUE GROUP BY column_name