Publicis Sapient interview question

Group by and having clause in sql