2022-12-11:行程和用戶(hù)。以下為輸出結(jié)果,請(qǐng)問(wèn)sql語(yǔ)句如何寫(xiě)?+------------+-------------------+| Day | Cancellation Rate |+------------+-------------------+| 2013-10-01 | 0.33 || 2013-10-02 | 0.00 || 2013-10-03 | 0.50 |+------------+-------------------+DROP TABLE IF EXISTS `trips`;CREATE TABLE `trips` ( `id` int(11) NOT NULL, `client_id` int(11) NOT NULL, `driver_id` int(11) NOT NULL, `city_id` int(11) NOT NULL, `status` enum('cancelled_by_client','cancelled_by_driver','completed') NOT NULL, `request_at` date NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;INSERT INTO `trips` VALUES ('1', '1', '10', '1', 'completed', '2013-10-01');INSERT INTO `trips` VALUES ('2', '2', '11', '1', 'cancelled_by_driver', '2013-10-01');INSERT INTO `trips` VALUES ('3', '3', '12', '6', 'completed', '2013-10-01');INSERT INTO `trips` VALUES ('4', '4', '13', '6', 'cancelled_by_client', '2013-10-01');INSERT INTO `trips` VALUES ('5#福大大架構(gòu)師每日一題#