冰淇淋12322

分类

/ 注册

全部文章（共30篇）

题解 | 数组中出现次数超过一半的数字

# # 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 # # # @param numbers int整型一维数组 # @return int整型 # class Solution: def MoreThanHalfNum_Solution(self , nu...

2026-03-03

0 7

题解 | 两数之和

# # 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 # # # @param numbers int整型一维数组 # @param target int整型 # @return int整型一维数组 # class Solution: def twoSum(...

2026-03-03

0 9

题解 | 字符串变形

#python # 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 # # # @param s string字符串 # @param n int整型 # @return string字符串 # class Solution: def trans(self ,...

2026-03-01

0 10

题解 | 微服务架构下的深层依赖链路漏洞影响面分析

with RECURSIVE temp as ( # 1、Payment_Gateway作为被调用，找到主调服务 select s2.service_id, s2.service_name, 1 as dependency_depth, concat(...

2026-03-01

2 20

题解 | 查询出每个品牌在不同月份的总销售额以及购买该品牌商品的用户的平均年龄

select category_id ,sum(order_amount) as total_sales ,sum(case when customer_gender = '男' then 1 else 0 end) as male_customers ,sum(case when custome...

2026-02-28

0 9

题解 | 物流公司想要分析快递小哥的薪资构成和绩效情况

select t1.courier_id, t1.courier_name, t1.base_salary+fee1-fee2 as total_income from couriers_info t1 left join ( select courier_id, sum(d...

2026-02-28

0 17

题解 | 查询出每个品牌在特定时间段内的退货率以及平均客户满意度评分

select so.brand_id, brand_name, round(sum(return_status)/count(so.order_id), 2) as return_rate_July_2024, round(avg(customer_satisfaction_score), 2) a...

2026-02-28

0 13

题解 | 每个顾客最近一次下单的订单信息

select order_id, customer_name, order_date from ( select order_id, customer_id, order_date, row_number() over(partition by customer_id order by order_...

2026-02-26

0 16

题解 | 医院门诊复诊率与抗生素用药占比统计

with t1 as ( select dept, count(distinct v.visit_id) as feb_2024_visits, count(distinct patient_id) as feb_2024_unique_patients, coalesce(sum(is_antib...

2026-02-26

0 15

题解 | 大整数哈希

n = int(input()) mod = 2**64 res = 0 d = {} for i in range(n): x,y = map(int,input().split()) if x not in d: res += (i+1)*0 d...

2026-02-25

0 13