蚊抑青年小王

分类

/ 注册

全部文章（共24篇）

题解 | 单组_补充前导零

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

2025-03-17

0 78

题解 | 单组_保留小数位数

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

2025-03-17

0 71

题解 | 更新用户积分信息？

select user_id, sum(order_price) + point point from order_tb join uservip_tb using (user_id) where order_price > 100 group by ...

2025-03-17

1 81

题解 | 统计用户获得积分

select user_id, sum( floor( timestampdiff (minute, visit_time, leave_time) / 10 ) ) point from visit_tb gr...

2025-03-16

1 69

题解 | 统计员工薪资扣除比例

select staff_id, staff_name, concat (round(dock_salary / normal_salary * 100, 1), '%') dock_ratio from staff_tb join salary_tb usi...

2025-03-15

0 84

题解 | 统计用户从访问到下单的转化率

select date, concat (round(order_num / visit_num * 100, 1), '%') cr from ( select date (visit_time) date, ...

2025-03-14

0 58

题解 | 查询下订单用户访问次数？

select user_id, count(user_id) visit_nums from visit_tb where date (visit_time) = '2022-09-02' and user_id in ( select ...

2025-03-13

0 70

题解 | 统计各等级会员用户下订单总额

select vip, sum(ifnull (order_price, 0)) order_total from order_tb right join uservip_tb using (user_id) group by vip order by ...

2025-03-12

0 80

题解 | 查询连续登陆的用户

select user_id from ( select user_id, count(user_id) cons_day from ( selec...

2025-03-11

0 56

题解 | 获取指定客户每月的消费额

select t.time, sum(t.t_amount) total from ( select t_time, DATE_FORMAT (t_time, '%Y-%m') time, ...

2025-03-05

0 52