Hi,
I have submitted by solution for Database problem # 262 and it has failed on 11th test case. I think the result of that testcase is wrong and my solution is correct.
Please help.
'''SELECT request_at AS Day,CAST(CAST(canceled AS DECIMAL(10,2))/total AS DECIMAL(10,2)) AS [Cancellation Rate] FROM
(SELECT t.request_at,
COUNT(CASE
WHEN status <> 'completed' THEN
1
ELSE
NULL
END) AS canceled,
COUNT(id) AS total
FROM trips t
INNER JOIN users d
ON d.users_id = t.driver_id
INNER JOIN users c
ON c.users_id = t.client_id
WHERE d.banned = 'No'
AND c.banned = 'No' GROUP BY t.request_at) AS tbl