小宇啊

分类

/ 注册

全部文章（共111篇）

题解 | #牛牛的选择#

a = {'Tencent':float(input())} b = {'Alibaba':float(input())} if a['Tencent'] > b['Alibaba']: print(list(a.keys())[0]) else: print(list(b....

2024-10-29

0 61

题解 | #牛客相亲网#

name1 = input() name2 = input() print(f"{name1} {name2}")

2024-10-29

0 46

题解 | #分别满足两个活动的人#

select * from (select uid, 'activity1' as activity from exam_record where year(start_time) = '2021' ...

2024-10-15

0 84

题解 | #每个题目和每份试卷被作答的人数和次数#

select * from (select exam_id as tid, count(distinct uid) as uv, count(uid) as pv from exam_record group ...

2024-10-15

0 57

题解 | #试卷发布当天作答人数和平均分#

select er.exam_id, count(distinct er.uid) as uv, round(avg(score),1) as avg_score from exam_record er inner join examination_info...

2024-10-15

0 74

题解 | #未完成试卷数大于1的有效用户#

select a.uid, sum(case when submit_time is null then 1 else 0 end) as incomplete_cnt, sum(case when submit_time is not null then 1 else 0 ...

2024-10-15

0 73

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

select b.tag, b.difficulty, round(avg(a.score),1) as clip_avg_score from exam_record a left join examination_info b on a.exam_id...

2024-10-11

0 181

题解 | #某宝店铺的SPU数量#

select style_id, count(item_id) as SPU_num from product_tb group by 1 order by SPU_num desc

2024-09-19

0 100

题解 | #纠错4#

select t.* from (SELECT cust_name, cust_contact, cust_email FROM Customers WHERE cust_state = 'MI' UNION SELECT cust_name...

2024-09-19

0 85

题解 | #将两个 SELECT 语句结合起来（二）#

select prod_id, quantity from OrderItems where (quantity = 100) or (prod_id like "BNBG%") order by 1

2024-09-19

0 82