许愿ssp的太平湖水怪很亲切

分类

/ 注册

全部文章（共8篇）

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

select count(distinct device_id) as did_cnt ,count(question_id)as question_cnt from question_practice_detail where date_format(date,'%Y-%m')='2021-08'...

2023-11-07

0 193

题解 | #每类视频近一个月的转发量/率#

select tag ,sum(if_retweet)retweet_cut ,round(sum(if_retweet)/count(video_id),3)retweet_rate from tb_user_video_log join tb_video_info using(video_id...

2023-11-04

0 169

题解 | #某乎问答11月份日人均回答量#

select answer_date,round(count(issue_id)/count(distinct author_id),2)per_num from answer_tb group by answer_date order by answer_date;

2023-11-04

0 207

题解 | #某宝店铺的实际销售额与客单价#

select sum(sales_price)'实际总销售额',round(sum(sales_price)/count(distinct user_id),2)'客单价'from sales_tb;

2023-11-04

0 206

题解 | #某宝店铺的SPU数量#

select style_id,count(inventory)spu from product_tb group by style_id order by spu desc; 这个题有点绕，看着很难，但是读懂题意之后就很简单了

2023-11-04

0 196

题解 | #有取消订单记录的司机平均评分#

select ifnull(driver_id,"总体")as driver_id,round(avg(grade),1)'平均评分' from tb_get_car_order where driver_id in (select driver_id from tb_get_c...

2023-11-03

0 177

sql

select '北京'as city ,round(avg(flag),3),round(avg(qian),3)from(select driver_id ,count(order_id)flag ,sum(fare)qian from tb_get_car_order join tb_get_c...

2023-11-03

0 211

题解 | #计算商城中2021年每月的GMV#

select date_format(event_time,'%Y-%m') as month,sum(total_amount)GMV from tb_order_overall where year(event_time)=2021 and status!=2 group by month ha...

2023-11-03

0 180