find out the percentage for each in sql : I got two table here, trip and users 
[![enter image description here][1]][1]


[![enter image description here][2]][2]


  [1]: https://i.stack.imgur.com/iL2V8.jpg
  [2]: https://i.stack.imgur.com/S05AQ.jpg


my question is Between Oct 1, 2013 at 10am PDT and Oct 22, 2013 at 5pm PDT, what percentage of requests made by unbanned clients each day were canceled in each city?_