陶良策

分类

/ 注册

全部文章（共52篇）

题解 | 密码翻译

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

2025-02-15

0 19

题解 | 查找学生信息

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

2025-02-15

0 13

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

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 308

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

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

2023-09-13

3 485

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

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

2023-09-10

0 284

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

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

2023-09-09

0 220

题解 | #查询被投递过的职位信息#

select company_id, count(*) 'cnt'from deliver_record d, job_info jwhere d.job_id = j.job_id and d.resume_if_checked = 1group by c...

2023-09-09

2 223

题解 | #牛奶供应问题#

import java.util.*; public class Solution { /** * 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 * * * @param taskDurations int整型一维数组...

2023-08-14

0 452

题解 | #牛牛的字符串解码问题#

import java.util.*; public class Solution { /** * 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 * * * @param s string字符串 * @re...

2023-08-02

0 356

题解 | #牛牛的三元组问题#

import java.util.*; public class Solution { /** * 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 * * * @param nums int整型一维数组 * ...

2023-08-02

0 334