不精独乐乐
不精独乐乐
全部文章
分类
归档
标签
去牛客网
登录
/
注册
不精独乐乐的博客
全部文章
(共156篇)
题解 | #某宝店铺动销率与售罄率#
select style_id, round(sum(sales_num)/(max(a)-sum(sales_num))*100,2), round(sum(sales_price)/max(b)*100,2) from sales_tb left join (select *, ...
2023-04-01
0
221
题解 | #兔子的数量#
def num(n): a = 2 b = 3 if n == 1: return a elif n == 2: return b else: return num(n-1)+num(n-2) n = int(...
2023-03-31
0
187
题解 | #单词造句#
a = [] while True: b = input() if b == '0': break else: a.append(b) c = ' '.join(a) print(c)
2023-03-29
0
234
题解 | #工作日各时段叫车量、等待接单时间和调度时间#
#思路: #①有订单就计入叫车量,所以要用叫车表左联接单表,保证叫车数据不丢失; #②调度时间是用上车时间-接单时间,上车时间可能是null,但不影响计算平均值,因为avg()会忽略null值; #③叫车表在左联之前,要将每日时间做分类。 select a, count(event_time) ...
2023-03-29
0
242
题解 | #错误出现的次数#
a = input().split() b = a.count('0') print(b)
2023-03-27
0
151
题解 | #数学幂运算#
a,b = map(int, input().split()) print(pow(a,b),pow(b,a),sep='\n')
2023-03-27
0
213
题解 | #国庆期间近7日日均取消订单量#
select dt, round(a/7,2), round(b/7,2) from( select distinct date(order_time) dt, count(fare)over(order by date(order_time) range interval 6 da...
2023-03-27
0
173
题解 | #每个城市中评分最高的司机信息#
with tb1 as( select city, driver_id, date(order_time) dt, mileage, grade from tb_get_car_order left join tb_get_car_record using(order_id)...
2023-03-26
0
242
题解 | #有取消订单记录的司机平均评分#
select ifnull(driver_id,'总体'), round(sum(grade)/count(driver_id),1) from (select driver_id from tb_get_car_order where start_time is null and finis...
2023-03-24
0
192
题解 | #店铺901国庆期间的7日动销率和滞销率#
with tb1 as( select product_id, shop_id, event_time, release_time from tb_order_detail left join tb_order_overall using(order_id) left join tb_product...
2023-03-22
0
314
首页
上一页
1
2
3
4
5
6
7
8
9
10
下一页
末页