WITH CTE1 AS ( SELECT CASE WHEN Location = 'A' THEN 'Los Angeles' WHEN Location ='B' THEN 'Fresno' ELSE 'San Jose' END as Location_Alias, Location, "Customer type" as Cust_Type, Gender, "Product line" as Product_Line, "Unit price(USD)", Quantity, Total, Date FROM 'City_Sales_Data.csv' ) SELECT Location_Alias, Cust_Type, Gender, Product_Line, ROUND(SUM(Total),2) as Total_Sales, ROUND(MEDIAN(Total),2) as Median_Sales FROM CTE1 GROUP BY 1,2,3,4 ORDER BY 1, 5 DESC;