陶良策

分类

/ 注册

全部文章（共66篇）

题解 | 打印极值点下标

#include <iostream> using namespace std; int main() { int k; int arr[80]; while (scanf("%d",&k)!=EOF) { // 注意 while 处...

2025-02-16

0 53

题解 | 与7无关的数

#include <iostream> using namespace std; int main() { int n; while (scanf("%d",&n)!=EOF) { // 注意 while 处理多个 case ...

2025-02-16

0 47

题解 | 吃糖果

#include <iostream> using namespace std; int main() { int N; while (scanf("%d",&N)!=EOF) { // 注意 while 处理多个 case ...

2025-02-15

0 40

题解 | skew数

#include <iostream> #include<vector> #include<cmath> using namespace std; int main() { string s1; vector<unsigned long l...

2025-02-15

0 36

题解 | 密码翻译

#include <cstdio> #include <iostream> using namespace std; int main() { int a, b; string s1; while (getline(cin,s1)) { // 注意 ...

2025-02-15

0 45

题解 | 查找学生信息

#include <iostream> #include<string> #include<map> using namespace std; using student = struct student{ //int num; string n...

2025-02-15

0 39

题解 | #返回每个顾客不同订单的总金额#

select cust_id, sumPrice from Orders a, (select order_num, sum(item_price*quantity) as sumPrice from OrderItems group by order_num) b where a.order_nu...

2023-10-10

0 320

题解 | #话题的分布情况#

select substring_index (subject_set, ',', 1) subject_id1, count(*) cnt from comment_detail where substring_index ((substring_index (su...

2023-09-13

3 513

题解 | #按城市对客户排序,如果城市为空，则按国家排序#

select *from customers_infoorder by ( case when city is not null then city else country end );

2023-09-10

0 289

题解 | #查询职位发布时间在2021年后或职位城市为上海#

select job_id, boss_id, company_idfrom ( select job_id, boss_id, company_id, job_city ...

2023-09-09

0 236