AVG(Salary) OVER (PARTITION BY GENDER) AS AVGSAL, MIN(Salary) OVER (PARTITION BY GENDER) AS MINSAL, MAX(Salary) OVER (PARTITION BY GENDER) AS MAXSAL FROM Employees -- ROW_NUMBER() OVER (PARTITON BY ..