小王子简约版

分类

/ 注册

全部文章（共10篇）

题解 | 字符串分隔

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

2025-12-01

0 8

题解 | 小红的优惠券

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

2025-11-26

0 9

题解 | 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary

select emp_no,salary,last_name,first_name from ( select e.emp_no,salary,first_name,last_name from employees e left join salaries s on e.emp_no = s...

2024-12-16

0 56

题解 | #最长连续登录天数#

select user_id,max(cnt) as max_consec_days from( select user_id,sub_result,count(*) cnt from( select user_id,date_sub(fdate,interval rn day) sub_resul...

2024-12-11

0 58

题解 | #国庆期间近7日日均取消订单量#

# select sum(case when b.dt between DATE_SUB(b.dt,INTERVAL 7 DAY) and b.dt then cancel_num else 0 end) cancel_num_7d,b.dt select '2021-10-01',round(su...

2024-11-26

0 83

题解 | #JS动态创建节点#

{"html":"<!DOCTYPE html>\n<html>\n\n<head>\n <meta charset=\"UTF-8\">\n <style>\n /...

2024-11-07

0 63

题解 | #每个月Top3的周杰伦歌曲#

select month,ranking,song_name,play_pv from( select month,rank()over(partition by month order by month,play_pv desc,song_id) ranking,song_name,play_pv...

2024-10-31

0 57

题解 | #2021年11月每天的人均浏览文章时长#

select dt,round(sum(date_diff)/count(distinct(uid)),1) as avg_view_len_scan from( select uid,timestampdiff(second,in_time,out_time) date_diff,date_for...

2024-09-14

0 108

题解 | #平均播放进度大于60%的视频类别#

select tag, concat(round(round(avg(if(date_diff / duration>1,1,date_diff/duration)),4)*100,2),"%") avg_rate # concat(round(av...

2024-09-14

0 137

题解 | #各个视频的平均完播率#

select c.video_id,(case when f_rate is null then 0.000 else f_rate end) f_rate from ( select distinct video_id from tb_user_video_log ) c left jo...

2024-09-11

0 110