Cognizant Interview Question

give some SQL queries using count()