爆栈炸死各位爷

分类

/ 注册

全部文章（共46篇）

题解 | #从 Products 表中检索所有的产品

select p.prod_name, o.quantity from Products p left join ( select prod_id,sum(quantity) quantity from OrderItems group by prod...

2023-11-15

0 71

题解 | #返回顾客名称和相关订单号#

select c.cust_name,o.order_num from Customers c inner join Orders o on o.cust_id = c.cust_id order by c.cust_name,o.order_num

2023-11-15

0 74

题解 | #返回产品名称和与之相关的订单号#

select p.prod_name,o.order_num from Products p left join OrderItems o on p.prod_id = o.prod_id order by p.prod_name

2023-11-15

0 63

题解 | #验证刷题效果，输出题目真实通过率#

select user_id, count(distinct if (result_info = 1, question_id, null)) / count(distinct question_id) as question_pass_rate, sum(result_in...

2023-11-15

0 68

题解 | #话题的分布情况#

SELECT SUBSTRING_INDEX(subject_set, ',', 1) subject_id1,COUNT(1) cnt FROM comment_detail WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(subject_set, ',',...

2023-11-15

0 102

题解 | #广告点击的高峰期#

SELECT DATE_FORMAT(click_time,'%H') click_hour,count(*) click_cnt from user_ad_click_time GROUP BY DATE_FORMAT(click_time,'%H') ORDER BY click_cnt ...

2023-11-15

0 60

题解 | #评论替换和去除#

select id, replace (comment, '，', '') comment from comment_detail where char_length(comment) > 3;

2023-11-12

0 81

题解 | #字符函数正则匹配2#

select id, comment from comment_detail where comment like '是%' or comment like '求%' order by id

2023-11-12

0 82

题解 | #输出在5min内完成点击购买的用户ID#

SELECT uact.user_id uid FROM user_ad_click_time uact LEFT JOIN user_payment_time upt ON upt.trace_id = uact.trace_id WHERE TIMESTAMPDIFF( MINUTE,...

2023-11-12

0 79

题解 | #输出提交且通过次数大于2 的用户ID且升序排列#

select user_id from done_questions_record group by user_id having sum(result_info) > 2

2023-11-11

0 89