JanisZhan
JanisZhan
全部文章
分类
题解(47)
归档
标签
去牛客网
登录
/
注册
JanisZhan的博客
全部文章
(共35篇)
题解 | #组合 Products 表中的产品名称和 Customers 表中的顾客名称#
(SELECT cust_name, cust_contact, cust_email FROM Customers WHERE cust_state = 'MI' UNION SELECT cust_name, cust_contact, cust_email FROM Customers WHE...
Mysql
2022-06-23
0
162
题解 | #纠错4#
(SELECT cust_name, cust_contact, cust_email FROM Customers WHERE cust_state = 'MI' UNION SELECT cust_name, cust_contact, cust_email FROM Customers WHE...
Mysql
2022-06-23
1
177
题解 | #每类视频近一个月的转发量/率#
select info.tag,sum(log.if_retweet) as retweet_cut, round((sum(log.if_retweet)/count(info.tag)),3) as retweet_rate from tb_video_info info righ...
Mysql
2022-06-22
3
320
题解 | #各个视频的平均完播率#
select info.tag,concat ( round(avg(if(timestampdiff(second,log.start_time,log.end_time)>=info.duration,100, timestampdiff(second,log.start_time,log...
Mysql
2022-06-22
1
276
题解 | #各个视频的平均完播率#
select log.video_id, round( sum(CASE WHEN log.end_time-log.start_time>=info.duration THEN 1 ELSE 0 END) /count(log.video_id),3) as avg...
Mysql
2022-06-22
1
203
首页
上一页
1
2
3
4
下一页
末页