Cognizant Interview Question

They asked me how to fetch a data using aggregrate functions in sql like count with certain conditions from database