找不着工作可咋办

题解

读书笔记(1)

/ 注册

全部文章 / 题解（共8篇）

题解 | #某滴出行2021年9月各城市每天的快车订单量#

select city_name,a.dt,count(distinct order_id) as flash_count from order_info_tb a left join driver_tb b on a.driver_id=b.driver_id left join city_tb ...

Mysql

2021-10-20

0 370

题解 | #某滴出行9月各城市每天的司机数#

select city_name,dt,count(distinct driver_id) as driver_num from driver_tb d left join city_tb c on d.city_id=c.city_id where month(dt)=9 group by d.c...

Mysql

2021-10-20

0 356

题解 | #小破站9月上中下旬的用户充值数量#

select (case when begin_date between '2021-09-01' and '2021-9-10' then '上旬' when begin_date between '2021-09-11' and '2021-9-20' then...

Mysql

2021-10-19

1 379

题解 | #灵魂社交APP2021年6月份月活#

select count(distinct(user_id)) as month_activate_user from login_tb where month(login_date)=6

Mysql

2021-10-19

1 356

题解 | #小破站9月新会员人数#

select count(distinct(user_id)) new_cnt from detail_list_tb where month(begin_date)=9 and user_id not in (select user_id from detail_list_tb where mo...

Mysql

2021-10-19

1 298

题解 | #某音短视频直播间晚上11-12点之间各直播间的在线人数#

select u.room_id,room_name,count(distinct user_id) as user_count from user_view_tb u left join room_info_tb r on u.room_id=r.room_id where (in_time BE...

Mysql

2021-10-19

0 427

题解 | #某音短视频直播间各个时间段的在线人数#

out time和in time有一个在范围内就可以算做该时间段在线 Select COUNT(IF((out_time BETWEEN '7:00:00' and '9:00:00') OR(in_time BETWEEN '7:00:00' and '9:00:00'), TRUE, NULL...

Mysql

2021-10-19

0 455

题解 | #某东618每一件商品的加购率#

select prd_id,round(sum(if_cart)/sum(if_vw),2) as cart_rate from tb_clk_rcd group by prd_id order by prd_id

Mysql

2021-10-19

0 662