The LIMIT and TOP clauses, Aggregate (Maximum Maximum (Sex, count) ..), Group By, more rollup with Group By, Having.
The LIMIT and TOP clauses, Aggregate (Sum, Average, Maximum, Minimum, Count), Group By, Rollup with Group By, Having.