谦虚的比尔在炒股

分类

/ 注册

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

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共78篇）

题解 | 未下单用户统计

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 13

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

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

2025-06-20

0 18

题解 | 统计每个产品的销售情况

select one.product_id, one.total_sales, one.unit_price, one.total_quantity, one.avg_monthly_sales, one...

2025-06-19

0 14

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

select od.order_id, c.customer_name, a.order_date from ( select customer_id, max(order_date) as order_date...

2025-06-19

0 18

题解 | 商品id数据清洗统计

select product_id, count(a.product_id) as cnt from ( select substr(order_id,6,4) as product_id from order...

2025-06-19

0 14

题解 | 查询订单

select od.order_id, c.customer_name, max_order_date as order_date from ( select customer_id, max(order_dat...

2025-06-19

0 12