katiehuangx / 8-Week-SQL-Challenge

Case study solutions for the #8WeekSQLChallenge.
https://8weeksqlchallenge.com
226 stars 161 forks source link

Update B. Runner and Customer Experience.md #10

Closed tseyongg closed 1 year ago

tseyongg commented 1 year ago

-previously, customer__id 102 had an order double counted; it was under the same order id, order id 3. Now, only two of his orders are taken into account, with distances 13.4 and 23.4 only. then (13.4 + 23.4)/2 = 18.4, rather than (13.4 +13.4 +23.4) / 3 = 16.73