This project showcases my work on data cleaning using SQL, focusing on a healthcare dataset. The primary goal was to ensure data quality and consistency by removing duplicates, standardizing data ...
SUM(CAST(optimized_route_cost AS FLOAT)) AS Total_Optimized_Cost, AVG(CAST(optimized_route_cost AS FLOAT)) AS Avg_Optimized_Cost, AVG(CAST(optimized_route_cost AS FLOAT) / NULLIF(CAST(distance_km AS ...