牛客485505005号

分类

题解(2)

/ 注册

全部文章（共4篇）

题解 | #单词倒排#

import re print(' '.join(re.sub('[^A-Za-z]+',' ',input()).split(' ')[::-1]))

2023-10-15

0 129

题解 | #求int型正整数在内存中存储时1的个数#

binary=lambda x: '' if x==0 else binary(x//2) +str(x%2) print(binary(int(input())).count('1'))

2023-02-21

0 138

题解 | MYsql 开窗函数#牛客每个人最近的登录日期(三)#

select date,sum(case when date=d then 1 else 0 end)from (select * ,min(date) over(partition by user_id) d from login) as agroup by dateorder by ...

2021-05-21

0 385

题解 | #MYSQL开窗函数#

SELECT round( sum( CASE WHEN date = date_add( d, INTERVAL 1 DAY ) THEN 1 ELSE 0 END )* 1 / sum( CASE WHEN date = d THEN 1 ELSE 0 END ...

2021-05-20

15 1269