What do you think about only capitalizing the first letter like this:
Select
region_fleet,
Case When status = 'Delivered' Then 'Delivered' Else 'Not Delivered' End As status,
Date_Trunc('week', day) As week,
Count(Distinct Row(day, so_number)) As num_orders,
Count(Distinct Case When scheduled_accuracy_meters <= 500 Then Row(day, so_number) Else Null End) As num_accurate,
Avg(scheduled_accuracy_meters) As scheduled_accuracy_meters
From
deliveries
Where
...
Group By
1, 2, 3
It's strange that he basically removed the entire history, but kept a couple of commits such that the 'face' gif can still be accessed?
Regardless, several forks exists with the original history dating back to 2016. So it's probably too late to do anything about now.