comicoding

分类

/ 注册

全部文章（共4篇）

题解 | 最长连续登录天数

with data1 as( select user_id, fdate, row_number() over (partition by user_id order by fdate asc) as rn from ...

2025-09-09

0 22

题解 | 饿了么需要分析不同配送员在不同天气条件下的配送效率和用户投诉情况

SELECT w1.weather_type, ROUND(AVG(dr1.delivery_time),2) AS average_delivery_time, COUNT(1) AS delivery_count FROM delivery_records dr...

2025-08-20

0 27

题解 | 近一个月发布的视频中热度最高的top3视频;

SELECT t2.video_id, CAST((100*t2.finish_rate + 5*t2.like_count + 3*t2.comment_count + 2*t2.retweet_count) * t2.fresh AS SIGNED) AS hot_index F...

2025-08-07

0 29

题解 | #单组_补充前导零#

import java.util.Scanner; // 注意类名必须为 Main, 不要有任何 package xxx 信息 public class Main { public static void main(String[] args) { Scanner in =...

2024-11-13

0 62