Publicis Sapient Interview Question

Group by and having clause in sql