牛客271112231号

分类

/ 注册

全部文章（共3篇）

题解 | #广告点击的高峰期#

select new.time click_hour, new.count click_cnt from( select date_format(click_time, '%H') time, row_number()over(order by sum(trace_id) desc) as rk, ...

2024-03-03

0 156

题解 | #截取出年龄#

select substring_index(substring_index(profile,',',-2), ',', 1) age, count(device_id) as number from user_submit group by age

2024-02-29

0 130

题解 | #定制显示器#

a = input() b = input() print('Happy ' + b +'th ' +'birthday to '+ a +'!')

2024-02-27

0 118