思考的陈

题解

/ 注册

全部文章 / 题解（共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 225

牛客的课程订单分析(六)

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 287

牛客的课程订单分析(二)

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 268