牛客638046884号

分类

/ 注册

全部文章（共8篇）

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

select user_id from ( select user_id, date_sub(log_time,interval rk day) as diff from ( select user_id, date(log_time) as log_time, row_number()over(...

2024-08-14

28 189

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

select user_id,room_id,room_type,days from ( select user_id,a1.room_id as room_id,room_type, datediff(date(checkout_time),date(checkin_time)) as days ...

2024-08-14

5 166

题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#

with biao1 as (select sales_date,user_id from sales_tb group by sales_date,user_id) select user_id,rmm as days_count from ( select user_id,diff, cou...

2024-08-13

0 141

题解 | #某宝店铺折扣率#

select round((sum(sa.sales_price)/(sum(sa.sales_num*pt.tag_price)))*100,2) as discount_rate from product_tb as pt right join sales_tb as sa on pt.ite...

2024-02-22

0 172

题解 | #每篇文章同一时刻最大在看人数#

select artical_id,max(uv) as max_uv from ( select artical_id,dt,sum(diff)over(partition by artical_id order by dt,diff desc) as uv from ( sel...

2024-02-21

0 131

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

select count(distinct device_id) as did_cnt,count(result) as question_cnt from question_practice_detail where year(date)=2021 and month(date)=8

2024-02-06

0 153

题解 | #提取博客URL中的用户名#

select device_id,substring_index(blog_url,"/",-1) user_name from user_submit 主要考察substring_index()函数的用法

2024-02-05

0 145

题解 | #统计每种性别的人数#

select if(substr(profile,15,1)="m","male","female") as gender,count(profile) as number from user_submit group by gender

2024-02-05

0 172