select a.Request_at as Day, round(count(if(a.Status!='completed', 1, null))/count(*), 2) as 'Cancellation Rate'
from Trips as a join Users as b
on a.Client_Id=b.users_Id and b.Banned='No' and a.Request_at between '2013-10-01' and '2013-10-03'
group by a.Request_at