在笔试的杰克很勤劳

分类

/ 注册

全部文章（共36篇）

题解 | #矩阵交换#

#include <stdio.h> int main() { int n, m; scanf("%d %d", &n, &m); int arr1[11][11]; for (int i = 0; i < n;...

2024-03-02

1 241

题解 | #回型矩阵#

#include <stdio.h> int main() { int n; scanf("%d", &n); int arr[20][20]; int up = 0, right = n - 1, left = 0, dow...

2024-03-01

1 244

题解 | #今天的刷题量(一)#

with b1 as (select date_format(now(),"%Y-%m-%d") create_time) select name,count(*) cnt from (select subject_id id, date_format(create_time...

2024-02-25

0 196

题解 | #牛牛学数列3#

#include <stdio.h> #include <math.h> int main() { int n; scanf("%d",&n); long double sum = 0.0; for(int i = ...

2024-02-25

1 213

题解 | #牛牛的快递#

#include <stdio.h> int main() { float a; char b; int amount = 0; scanf("%f %c",&a,&b); if(a <= 1){ ...

2024-02-23

1 206

题解 | #牛牛的计划#

import sys from datetime import datetime start_list = ''.join(input().split()) now_list = ''.join(input().split()) start_date = datetime.strptime(st...

2024-02-09

1 215

题解 | #

select zb1.author_id,author_level,days_cnt from (select author_id,count(fuzhu) days_cnt /*通过连登录天数*/ from (select distinct answer_date,author_id, answ...

2023-12-28

1 205

题解 | #牛客直播各科目同时在线人数#

with zb as (select ct.course_id,ct.course_name,in_datetime,out_datetime,1 as in_num,-1 as leave_num /*将进入时间标记为1,离开记-1*/ from course_tb ct left join at...

2023-12-28

1 285

题解 | #牛客直播各科目出勤率#

select zb1.course_id,zb1.course_name,round(attend_num*100/sign_num,2) 'attend_rate(%)' from (select ct.course_id,course_name,count(distinct user_id) ...

2023-12-28

1 195

题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#

select user_id,count(user_id) days_count from (select *,sales_date-row_number() over(partition by user_id order by sales_date) sss /*连续登录天数通用,相减相等个数即...

2023-12-28

1 207