Salient Management Interview Question

How do you count frequency in SQL?