--It wont allow any column in select clause that is not part of GROUP BY clause. AVG(Orderamount) OVER(PARTITION BY Customercity) AS AvgOrderAmount, MIN(OrderAmount) OVER(PARTITION BY Customercity) AS ...