proc sql; title "Employee with the Highest Total Sales"; select Employee_ID ne 99999999, sum(Total_retail_price*Quantity) as Total_Sales from orion.Order_Fact group by Employee_ID having calculated Total_Sales >= all (select sum(Total_retail_price*Quantity) as Total_Sales from orion.Order_Fact) ; quit; title;
... View more
