Salient Management interview question

How do you count frequency in SQL?