Cognizant interview question

give some SQL queries using count()