The group by clause allows you to break down analysis even further by creating up to 4 groupings within charts…