round(sum(if(t.Status = 'completed', 0, 1))/count(1),2) as
from Trips t
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;
Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.