str浩

分类

题解(4)

/ 注册

全部文章（共18篇）

题解 | #查询每天刷题通过数最多的前二名用户id和刷题数#

SELECT date,user_id,pass_count FROM ( SELECT user_id, pass_count, date, row_number () over ( PARTITION BY date ORDER BY pass_count DESC ) rk FROM...

2023-08-13

0 345

题解 | #分群并计算群体人数#

SELECT ( CASE WHEN age < 20 THEN '20以下' WHEN age >= 20 AND age <= 50 THEN '20-50' ...

2023-08-13

0 295

题解

select * from customers_info order by( case when city is not null then city else country end )

2023-08-13

15 341

题解 | #判断其是否有过购买记录#

SELECT customer_id, CASE WHEN latest_place_order_date IS NOT NULL THEN 1 WHEN latest_place_order_date IS NULL THEN 0 END AS if_placed_o...

2023-08-12

0 311

题解 | #判断其是否有过购买记录#

SELECT customer_id, IF (latest_place_order_date, 1, 0) AS if_placed_order FROM customers_info

2023-08-12

0 341

题解|

SELECT job_id, boss_id, company_id FROM ( SELECT job_id, boss_id, company_id, ...

2023-08-12

0 243

题解 |

SELECT job_id, company_id FROM job_info WHERE job_city = '北京' UNION ALL SELECT job_id, company_id FROM job_info WHERE salary > 100000

2023-08-12

0 302

题解 | #查询每个公司查看过的投递用户数#

SELECT ji.company_id, COUNT( dr.user_id ) AS cnt FROM job_info AS ji INNER JOIN deliver_record AS dr ON ji.job_id = dr.job_id WHERE dr.resume_i...

2023-08-09

0 311

题解 | #查询2022年毕业用户的刷题记录#

# select user_id from user_info where graduation_year = 2022 # SELECT # * # FROM # questions_pass_record AS qpr # WHERE # qpr.user_id IN ( SELEC...

2023-08-07

0 308

题解 | #21年8月份练题总数#

SELECT COUNT(DISTINCT device_id) did_cnt, COUNT(date) AS question_cnt FROM question_practice_detail WHERE MONTH (date) = 8

2023-08-06

0 269