欧美1区2区3区激情无套,两个女人互添下身视频在线观看,久久av无码精品人妻系列,久久精品噜噜噜成人,末发育娇小性色xxxx

現(xiàn)有某個商城部分訂單數(shù)據(jù)，用戶訪問數(shù)據(jù)，如下所示： 訂單信息表：order_tb（訂單id：order_id，用戶id：user_id，訂單金額：order_price，訂單創(chuàng)建時間：order_time） order_id user_id order_price order_time 101 11 380 2022-09-01 09:00:00 102 12 200 2022-09-01 10:00:00 103 13 260 2022-09-01 12:00:00 104 11 100 2022-09-02 11:00:00 105 12 150 2022-09-02 12:00:00 106 12 1200 2022-09-02 13:00:00 107 11 60 2022-09-03 09:00:00 108 13 380 2022-09-03 09:30:00 訪問信息表：visit_tb（訪問信息id：info_id，用戶id：user_id，訪問時間：visit_time，離開時間：leave_time） info_id user_id visit_time leave_time 911 10 2022-09-01 08:00:00 2022-09-01 09:02:00 912 11 2022-09-01 08:30:00 2022-09-01 09:10:00 913 12 2022-09-01 09:50:00 2022-09-01 10:12:00 914 13 2022-09-01 11:40:00 2022-09-01 12:22:00 921 11 2022-09-02 10:30:00 2022-09-02 11:05:00 922 11 2022-09-02 12:00:00 2022-09-02 12:02:00 923 12 2022-09-02 11:40:00 2022-09-02 13:15:00 924 13 2022-09-02 09:00:00 2022-09-02 09:02:00 925 14 2022-09-02 10:00:00 2022-09-02 10:40:00 931 10 2022-09-03 09:00:00 2022-09-03 09:22:00 932 11 2022-09-03 08:30:00 2022-09-03 09:10:00 933 13 2022-09-03 09:00:00 2022-09-03 09:32:00 請統(tǒng)計該商城每天用戶從訪問到下訂單的轉(zhuǎn)化率。 要求輸出：日期，轉(zhuǎn)化率（該日下訂單人數(shù)訪問人數(shù)，以百分數(shù)形式輸出并四舍五入保留1位小數(shù)） 注：輸出結(jié)果按照日期升序排序； 示例數(shù)據(jù)結(jié)果如下： date cr 2022-09-01 75.0% 2022-09-02 50.0% 2022-09-03 66.7% 結(jié)果解釋： 以2022-09-01為例，該日共計有user_id為10、11、12、13共計4名用戶訪問商城， 其中11、12、13共計3名用戶下了訂單，故轉(zhuǎn)化率為34=75.0%； 其他結(jié)果同理。
示例1

輸入

drop table if exists  `order_tb` ; 
CREATE TABLE `order_tb` (
`order_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`order_price` int(11) NOT NULL,
`order_time` datetime NOT NULL,
PRIMARY KEY (`order_id`));
INSERT INTO order_tb VALUES(101,11,380,'2022-09-01 09:00:00'); 
INSERT INTO order_tb VALUES(102,12,200,'2022-09-01 10:00:00'); 
INSERT INTO order_tb VALUES(103,13,260,'2022-09-01 12:00:00'); 
INSERT INTO order_tb VALUES(104,11,100,'2022-09-02 11:00:00'); 
INSERT INTO order_tb VALUES(105,12,150,'2022-09-02 12:00:00'); 
INSERT INTO order_tb VALUES(106,12,1200,'2022-09-02 13:00:00'); 
INSERT INTO order_tb VALUES(107,11,60,'2022-09-03 09:00:00'); 
INSERT INTO order_tb VALUES(108,13,380,'2022-09-03 09:30:00'); 

drop table if exists  `visit_tb` ; 
CREATE TABLE `visit_tb` (
`info_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`visit_time` datetime NOT NULL,
`leave_time` datetime NOT NULL,
PRIMARY KEY (`info_id`));
INSERT INTO visit_tb VALUES(0911,10,'2022-09-01 08:00:00','2022-09-01 09:02:00'); 
INSERT INTO visit_tb VALUES(0912,11,'2022-09-01 08:30:00','2022-09-01 09:10:00'); 
INSERT INTO visit_tb VALUES(0913,12,'2022-09-01 09:50:00','2022-09-01 10:12:00'); 
INSERT INTO visit_tb VALUES(0914,13,'2022-09-01 11:40:00','2022-09-01 12:22:00'); 
INSERT INTO visit_tb VALUES(0921,11,'2022-09-02 10:30:00','2022-09-02 11:05:00'); 
INSERT INTO visit_tb VALUES(0922,11,'2022-09-02 12:00:00','2022-09-02 12:02:00'); 
INSERT INTO visit_tb VALUES(0923,12,'2022-09-02 11:40:00','2022-09-02 13:15:00'); 
INSERT INTO visit_tb VALUES(0924,13,'2022-09-02 09:00:00','2022-09-02 09:02:00'); 
INSERT INTO visit_tb VALUES(0925,14,'2022-09-02 10:00:00','2022-09-02 10:40:00'); 
INSERT INTO visit_tb VALUES(0931,10,'2022-09-03 09:00:00','2022-09-03 09:22:00'); 
INSERT INTO visit_tb VALUES(0932,11,'2022-09-03 08:30:00','2022-09-03 09:10:00'); 
INSERT INTO visit_tb VALUES(0933,13,'2022-09-03 09:00:00','2022-09-03 09:32:00');

輸出

date|cr
2022-09-01|75.0%
2022-09-02|50.0%
2022-09-03|66.7%
加載中...