哈哈士奇

分类

题解(1)

/ 注册

全部文章（共4篇）

题解 | #大小写混乱时的筛选统计#

with t as ( select tag, count(1) as cnt from exam_record join examination_info on exam_record.exam_id=examination_info.exam_id group by tag ...

2024-11-26

0 34

题解 | #获取指定客户每月的消费额#

select substr(t_time,1,7) as time, sum(t_amount) total from trade join customer on trade.t_cus=customer.c_id where c_name='Tom' and year(t_time)='2...

2024-11-26

0 39

题解 | #分析客户逾期情况#

select c.pay_ability, concat( FORMAT(sum(case when coalesce(overdue_days,0)>0 then 1 else 0 end) /count(1)*100,1),'%') as overdue_ratio fro...

2024-11-26

0 26

题解 | #最长连续登录天数#

select user_id, max(lasting)+1 as max_consec_days from ( select user_id, init_day, max(row_number1)-min(row_number1) lasting from ( select ...

2024-11-25

0 41