思考的陈
思考的陈
全部文章
分类
题解(7)
归档
标签
去牛客网
登录
/
注册
KEY TO EXERCISES
TA的专栏
24篇文章
13人订阅
Java Offer训练营
24篇文章
1367人学习
全部文章
(共3篇)
内连接即可
SELECT a.date,ROUND(have/sum,3) AS 'p' FROM (SELECT date,COUNT(*) AS 'have' FROM email WHERE type='no_completed' AND send_id NOT IN (SELECT id FROM ...
Mysql
2021-10-02
0
221
牛客的课程订单分析(六)
SELECT o.id,is_group_buy,name AS 'client_name' FROM order_info o LEFT JOIN client c ON o.client_id=c.id WHERE user_id IN (SELECT user_id FROM order_...
Mysql
2021-08-29
0
285
牛客的课程订单分析(二)
SELECT DISTINCT(t1.user_id) FROM order_info t1 JOIN (SELECT user_id ,COUNT(user_id) AS 'count' FROM order_info WHERE status='compl...
Mysql
2021-08-02
0
267