谦虚的比尔在炒股

分类

/ 注册

TA的专栏 0篇文章 0人订阅

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共82篇）

题解 | 最受欢迎的top3课程

select cid, pv, time_len from ( select prt.cid, avg(score) as avg_score, count(if(date(prt.start_t...

2025-07-03

0 6

题解 | 更新员工信息表

select ei.EMPLOYEE_ID, if(ei.LAST_UPDATE_DT < per_eu.UPDATE_DT,per_eu.NEW_POSITION,ei.POSITION) as POSITION, if(ei.LAST_UPD...

2025-07-03

0 5

题解 | 未下单用户登陆渠道统计

select ui.channel, count(ui.channel) as cnt from user_info as ui left join ( select distinct uid from ...

2025-07-03

0 4

题解 | 用户订单信息查询

select ct.city, sum(od.total_amount) as total_order_amount from orders as od left join customers as ct on o...

2025-07-03

0 5

题解 | 未下单用户统计

select count(ui.uid) - count(ol.uid) as cnt from user_info as ui left join order_log as ol on ui.uid = ol.uid

2025-07-02

0 13

题解 | 返回顾客名称和相关订单号以及每个订单的总价

select c.cust_name, o.order_num, oi.quantity * oi.item_price as OrderTotal from Customers as c inner join O...

2025-07-02

0 12

题解 | 输出播放量最高的视频

select cid, cast(max(cnt) as decimal(10,3)) as max_peak_uv from ( select prt.cid, count(if(prt.start_time between ...

2025-07-02

0 12

题解 | 输出播放量最高的视频

select cid, cast(max(cnt) as decimal(10,3)) as max_peak_uv from ( select prt.cid, count(if(prt.start_time between ...

2025-07-02

0 12

题解 | 每个顾客购买的最新产品名称

select a.customer_id, customer_name, product_name as latest_order from ( select customer_id, product_id, ...

2025-06-20

0 14

题解 | 各个部门实际平均薪资和男女员工实际平均薪资

select department, round(sum(normal_salary - dock_salary) / count(department),2) as average_actual_salary, ifnull(round(sum(if...

2025-06-20

0 20