不精独乐乐

分类

/ 注册

全部文章（共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