KarrySmile

分类

/ 注册

全部文章（共3篇）

题解 | 使用sum if和子查询完成

with temp as ( select author_id from answer_tb a left join issue_tb i on a.issue_id = i.issue_id group by author_i...

2024-08-13

0 95

题解 | 三个union的暴力解法

with temp as ( select '5-6级' as level_cut, count(*) as num from answer_tb a left join author_tb u on a.author_id = u.author_id where ...

2024-08-13

0 110

题解|#返回每个顾客不同订单的总金额#inner join

select cust_id, sum(item_price * quantity) as total_ordered from OrderItems inner join Orders on OrderItems.order_num = Orders.order_n...

2024-07-26

1 80