SELECT fieldName, COUNT(*) FROM $Table_name$
GROUP BY fieldName;  /* you can add WHERE condition or use MIN(), MAX(), AVG(), SUM() */