2022-12-11:行程和用户。以下为输出结果,请问sql语句如何写?
+------------+-------------------+
| 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
#福大大架构师每日一题#
+------------+-------------------+
| 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
#福大大架构师每日一题#
全部评论
每天学习一点
相关推荐
06-03 16:55
广州工商学院 单片机 点赞 评论 收藏
分享

点赞 评论 收藏
分享