牛客52838656号

分类

/ 注册

全部文章（共26篇）

题解 | #列出供应商及其可供产品的数量#

select t1.vend_id,count(prod_id) from Vendors t1 left join Products t2 on t1.vend_id=t2.vend_id group by t1.vend_id order by t1.vend_id asc

2023-08-15

0 326

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

select cust_name,sum(item_price*quantity) total_price from Customers t1 inner join Orders t2 on t1.cust_id=t2.cust_id inner join OrderItems t3 on t2.o...

2023-08-04

0 293

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

select t1.cust_name,t2.order_num,sum(t3.quantity*t3.item_price) OrderTotal from Customers t1,Orders t2,OrderItems t3 where t1.cust_id=t2.cust_id and t...

2023-08-04

0 270

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

select t2.cust_id,sum(t1.quantity*t1.item_price) total_ordered from OrderItems t1,Orders t2 where t1.order_num=t2.order_num group by t2.cust_id order...

2023-08-04

0 278

题解 | #21年8月份练题总数#

select count(distinct device_id) as did_cnt, count(question_id) as question_cnt from question_practice_detail where month(date)=8

2023-08-03

0 303

题解 | #浙大不同难度题目的正确率#

select t3.difficult_level, round(sum(if(t2.result='right',1,0))/count(t2.question_id),4) as correct_rate from user_profile t1,question_practice_d...

2023-08-03

1 288