刷个题先

分类

/ 注册

全部文章（共27篇）

题解 | #月均完成试卷数不小于3的用户爱作答的类别#

select tag,count(tag) from exam_record er left join examination_info ei on er.exam_id=ei.exam_id ...

2022-11-11

0 245

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

select cust_name,order_num from Customers c,Orders o where c.cust_id=o.cust_id order by cust_name,...

2022-11-08

0 197

题解 | Products 表检索所有产品名称及对应销售总数

select prod_name,( select sum(quantity) quant_sold from OrderItems b &nb...

2022-11-08

0 229

题解 | #统计复旦用户8月练题情况#

select a.device_id,a.university,count(question_id) question_cnt,sum(if(b.result='right',1,0)) as right_question_cnt ...

2022-11-07

0 203

题解 | #统计每种性别的人数#

select case when profile like '%female' then 'female' else 'male' end as ...

2022-11-07

0 228

题解 | #计算25岁以上和以下的用户数量#

select case when age>=25 then '25岁及以上' else '25岁以下' end as age_cut,count(*) ...

2022-11-04

0 203

题解 | #按照数量和价格排序#

select quantity,item_price from OrderItems order by quantity desc,item_price desc; 根据题目要求，按照数量降序排序，再根据价格降序排序

2022-11-03

0 253