找工作好难玉玉了😇

分类

/ 注册

全部文章（共97篇）

题解 | #平均活跃天数和月活人数#

WITH v1 AS( SELECT uid, REPLACE(LEFT(submit_time, 10), '-', '') month FROM exam_record WHERE submit_time IS NOT NULL AND YEAR(submit_time)...

2023-10-06

0 268

题解 | #得分不小于平均分的最低分#

WITH jun AS( SELECT a.*, b.tag FROM exam_record a INNER JOIN examination_info b ON a.exam_id = b.exam_id WHERE tag = 'SQL' AND sco...

2023-10-06

1 250

题解 | #统计作答次数#

SELECT COUNT(CASE WHEN start_time IS NOT NULL THEN 1 ELSE NULL END) total_pv, COUNT(CASE WHEN submit_time IS NOT NULL THEN 1 ELSE NULL END) total...

2023-10-06

0 278

题解 | #SQL类别高难度试卷得分的截断平均值#

WITH Rank_view AS( SELECT tag, difficulty, score, ROW_NUMBER() OVER(PARTITION BY a.exam_id ORDER BY score ASC) MIN_SCORE, ROW_NUMBER() OVER(PARTITION ...

2023-10-06

0 289

题解 | #确定最佳顾客的另一种方式（二）#

SELECT a.cust_name, SUM(c.item_price*c.quantity) total_price FROM Customers a INNER JOIN Orders b ON a.cust_id = b.cust_id INNER JOIN OrderItems c ON ...

2023-10-02

0 232

题解 | #返回购买 prod_id 为 BR01 的产#

SELECT a.cust_email FROM Customers a INNER JOIN Orders b ON a.cust_id = b.cust_id INNER JOIN OrderItems c ON b.order_num = c.order_num WHERE c.prod_id...

2023-10-02

0 356

题解 | #确定哪些订单购买了 prod_id #

SELECT cust_id, order_date FROM Orders WHERE order_num IN ( SELECT order_num FROM OrderItems WHERE prod_id = 'BR01' ) ORDER BY order_date...

2023-10-02

0 301

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

SELECT a.cust_name, b.order_num, c.quantity*c.item_price OrderTotal FROM Customers a LEFT JOIN Orders b ON a.cust_id = b.cust_id LEFT join OrderItems...

2023-10-02

0 329

题解 | #返回顾客名称和相关订单号#

SELECT a.cust_name, b.order_num FROM Customers a INNER JOIN Orders b ON a.cust_id = b.cust_id ORDER BY a.cust_name, b.order_num 思路：1.查询顾客名称，来源于表a2.查询订...

2023-10-02

0 263

题解 | #从 Products 表中检索所有的产品名称#

SELECT a.prod_name, b.quant_sold FROM Products a, ( SELECT prod_id, SUM(quantity) quant_sold FROM OrderItems GROUP BY prod_id) b WHERE a...

2023-10-02

0 284