唐宇轩

分类

题解(3)

/ 注册

全部文章（共3篇）

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

SELECT cust_id,total_ordered FROM Orders AS o JOIN ( SELECT order_num,SUM(item_price * quantity) AS total_ordered ...

Mysql

2022-04-10

0 292

题解 | #确定 Products 表中价格不超过 10 美元的最贵产品的价格#

select prod_price as max_price from Products where prod_price<=10 order by prod_price desc limit 1

Mysql

2022-04-10

0 320

题解 | #计算用户8月每天的练题数量#

select dayofmonth(date)as day ,count(*) as question_cnt from question_practice_detail where month(date)=8 group by dayofmonth(date) 欢迎大家一起吐槽（交流）

Mysql

2022-04-06

0 303