纯真的铁锤不愿再收感谢信

分类

/ 注册

全部文章（共13篇）

题解 | #每个商品的销售总额#

SELECT p.name AS product_name, SUM(o.quantity) AS total_sales, RANK() OVER (PARTITION BY p.category ORDER BY SUM(o.quantity) DESC, p.produ...

2024-11-26

3 40

题解 | #查询连续入住多晚的客户信息？#

SELECT user_id, ct.room_id, room_type, DATEDIFF(DATE(checkout_time), DATE(checkin_time)) AS days FROM checkin_tb ct LEFT JOIN ...

2024-11-25

0 47

题解 | #找出每个学校GPA最低的同学#

select device_id, university, gpafrom (select device_id, university, gpa, rank() over(PARTITION by university order by gpa) as rg...

2024-11-24

0 44