七念叶

分类

/ 注册

全部文章（共6篇）

题解 | #查询连续入住多晚的客户信息？#

select * from (select c.user_id, c.room_id, g.room_type, datediff(date(c.checkout_time),date(c.checkin_time)) as...

2024-08-28

1 108

题解 | #查询连续登陆的用户#

with t1 as (select user_id from register_tb where reg_time >='2022-02-08 00:00:00') ,t2 as (select user_id, date(log_time) as dt, row_number()over...

2024-08-27

1 120

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

with t1 as (select pay_ability,count(customer_id) as all_user_cnt from customer_tb group by pay_ability) ,t2 as (select a.pay_ability,a.customer_id,b...

2024-08-26

1 115

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

select user_id,max(consec_days) as max_consec_days from (select b.user_id, b.first_date, count(b.first_date) as consec_days fro...

2024-08-26

13 173

题解 | #每个月Top3的周杰伦歌曲#

WITH t1 AS ( SELECT month(fdate) AS month, DATE_FORMAT(fdate, '%Y') AS year, song_id, COUNT(user_id) AS ...

2024-08-24

1 158

题解 | #格式化输出（一）#

name=input() print('I am ' + name +' and I am studying Python in Nowcoder!')

2023-11-29

1 160