is it ok this solution in mssql?

In run code is accepted but when i submitted it is wrong
any idea?
"""
select
request_at as Day,
round(cast( count( case when status like 'cancelled%' then 1 end ) as float) / cast(count( * ) as float),2) as [Cancellation Rate]

from
trips,
(select users_id as id from users where banned = 'yes') u
where
client_id != u.id
and
driver_id != u.id
and
request_at between '2013-10-01' and '2013-10-03'
group by
request_at
"""

Comments (1)