Create trips-and-users.sql

kamyu104 · kamyu104 · commit dd4cb7ff53fc · 2015-08-19T10:19:58.000+08:00
diff --git a/MySQL/trips-and-users.sql b/MySQL/trips-and-users.sql
@@ -0,0 +1,11 @@
+# Time:  O((t * u) + tlogt)
+# Space: O(t)
+
+select 
+t.Request_at Day, 
+round(sum(case when t.Status like 'cancelled_%' then 1 else 0 end) / count(*), 2) Rate
+from Trips t
+inner join Users u 
+on t.Client_Id = u.Users_Id and u.Banned='No'
+where t.Request_at between '2013-10-01' and '2013-10-03'
+group by t.Request_at
