小宇啊

分类

/ 注册

全部文章（共111篇）

题解 | 符合销售额的品牌信息

select a.品牌号, b.品牌名, count(c.品类号) as 品类号数量 from 月销售统计表 a inner join 品牌表 b on a.品牌号 = b.品牌号 inner join 品类表 c on a.品类号 = c.品类号...

2025-11-14

0 10

题解 | 不同电商平台的销售额

select a.品牌号, b.品牌名, a.品类号, c.品类名, a.电商平台, sum(a.销售额) as 销售额 from 月销售统计表 a inner join 品牌表 b on a.品牌号 = b.品牌号 inner jo...

2025-11-14

0 14

题解 | 邮件发送成功概率

select a.日期, sum(case when a.枚举类型 = 'no_completed' then 1 else 0 end) / count(a.枚举类型) as 失败率 from 邮件表 a left join 用户表 b on a.寄信人编号 ...

2025-11-14

0 8

题解 | 三表连接

select c.商品类型, sum(a.支付金额) as 支付金额, sum(b.总运费) as 总运费, sum(b.总运费) / sum(a.支付金额) as 运费占比 from 订单表 a left join 运费表 b on a.订单号 ...

2025-10-20

0 14

题解 | 库存分析

select a.商品号, a.尺码, sum(b.库存数) / sum(a.近7天销量) as 存销比 from 订单表 a left join 库存表 b on a.商品号 = b.商品号 and a.尺码 = b.尺码 group by 1,...

2025-09-12

0 23

题解 | 店铺销售的排名

import numpy as np data = np.genfromtxt('Shop.csv',delimiter = ',',dtype = [('shop','S50'),('sales','float')],encoding='utf-8') sorted_data = np.sor...

2025-08-08

0 32

题解 | 程序员工资的运算

import numpy as np data = np.loadtxt('Salary.csv',delimiter=',') col_medians = np.median(data,axis=0) row_means = np.round(np.mean(data,axis=1),1) ...

2025-08-06

0 24

题解 | 打印文件的最后5行

#!/bin/bash tail -n 5 nowcoder.txt

2025-08-04

0 39

题解 | 程序员的工资统计

import numpy as np data = np.genfromtxt('Salary.csv',delimiter=',',dtype=float) regional_max = np.max(data,axis=1) job_diffs = np.max(data,axis=0) -...

2025-08-04

0 35

题解 | 格式化百度爬虫数据

import numpy as np data = np.genfromtxt('Spider.csv',dtype=str,delimiter=',',encoding='utf-8',comments=None) data_flat = data.flatten() data_strippe...

2025-08-04

0 45