csp模拟2nd_A-HRZ的序列

本文详细解析了A-HRZ序列问题的解决思路,通过分析数据的三种情况,利用set去重统计数种,巧妙地判断并输出结果。适用于初学者理解算法设计与实现。

A-HRZ的序列


题目描述

在这里插入图片描述

题目思路

这个题目我们可以经过分析答案总共有三种情况:
1.数据中有两种数,此时满足情况,输出YES
2.数据中有三种数,此时需要判断,这里我们是求最小数和最大数的中位数,然后判断这个中位数和中间的那个数是否相同,相同即是YES,否则是NO
3.数据中大于三种数,此时不满足情况,输出NO

这个题目刚开始做的时候我想得太复杂,没有考虑到数据的情况,只想着去模拟。

这个题目中我们可以巧妙的使用set来去除重复,统计数据的种数。

实现代码

//#include <bits/stdc++.h>
#include <iostream>
#include <algorithm>
#include <cstdio>
#include <cmath>
#include <set> 
#define _for(i,a,b) for(int i = (a); i < (b); i++)
#define _rep(i,a,b) for(int i = (a); i <= (b); i++) 
using namespace std;

const int MAXN = 1e4 + 10;
int t,n;
long long a[MAXN];
set<long long> s;
bool flag;
long long sum,avg;
long long ans;

int main()
{
	scanf("%d",&t);
	_for(i,0,t)
	{

		s.clear();
		scanf("%d",&n);
		if(n != 2)
		{
			_for(j,0,n)
			{
				scanf("%lld",&a[j]);
				s.insert(a[j]); 

			}
			if(s.size() <= 2)	printf("YES\n");
			else if(s.size() > 3)	printf("NO\n");
			else{
				sort(a,a+n);
				ans = (a[0] + a[n-1]) / 2;
				if(s.find(ans) != s.end())
					printf("YES\n");
				else
					printf("NO\n");
			}
		}
	}
} 
我这里有一条oracle执行的sql,执行单时间挺长,需要你帮我对它进行优化,提高查询效率 select LAST_DAY(TO_DATE(a.PERIOD_NAME,'YYYY-MM')) as STATDATE, case when b.MANAGER_COM = '869701' then '860097' else b.MANAGER_COM end as COMCODE, null as COMNAME, '3' as COMLEVEL, substr(b.MANAGER_COM,1,4) as PARENT_CODE, 'YX' as CHANNEL_CODE, '营销' as CHANNEL_NAME, sum(case when a.line_name in ('L_200-营销首年佣金','L_215-中心城市首年佣金') then a.actual_used_of else null END) as FIRST_FEE_A, -- 首期佣金 累计达成额 sum(case when a.line_name in ('L_200-营销基本法','L_215-中心城市基本法') then a.actual_used_of else null END) as FIRST_FEE_JBEN_A, -- 首期基本法 累计达成额 sum(case when a.line_name in ('L_215-中心城市业务费用','L_200-营销业务费用小计', 'L_200-营销培训费用小计', 'L_200-营销专项费用小计', 'L_200-营销聘才专项', 'L_200-营销将星/利剑/续航等', 'L_200-营销磐龙专项等') then a.actual_used_of else null END) as FIRST_FEE_YWTDJY_A, -- 首期业务推动经营费用 累计达成额 sum(case when a.line_name in ('L_200-营销业务推动费用','L_215-中心城市业务推动费用','L_215-中心城市协解费用专项','L_215-中心城市人力发展费用','L_200-营销人力发展费用','L_200-营销聘才专项', 'L_200-营销将星/利剑/续航等', 'L_200-营销磐龙专项等') then a.actual_used_of else null END) as FIRST_FEE_JL_A,-- 首期激励方案费用 累计达成额 sum(case when a.line_name in ('L_200-营销培训费用小计','L_215-中心城市培训费用小计') then a.actual_used_of else null END) as FIRST_FEE_YWPX_A, -- 首期业务培训费用 累计达成额 sum(case when a.line_name in ('L_200-营销专项费用小计','L_215-中心城市专项费用小计') then a.actual_used_of else null END) as FIRST_FEE_QT_A, -- 首期其他费用 累计达成额 null as FIRST_FEE_JX_A, -- 首期绩效 累计达成额 null as FIRST_FEE_SXF_A, -- 首期手续费 累计达成额 sum(case when a.line_name in ('L_200-营销首年佣金','L_215-中心城市首年佣金','L_200-营销基本法','L_215-中心城市基本法','L_215-中心城市业务费用','L_200-营销业务费用小计', 'L_200-营销培训费用小计', 'L_200-营销专项费用小计', 'L_200-营销聘才专项', 'L_200-营销将星/利剑/续航等', 'L_200-营销磐龙专项等') then a.actual_used_of else null END) as FIRST_FEE_BDSJ_A from MISOPER.YGBX_REPORT_DETAILS_INTERFACE_TMP a left join MISOPER.T_SLFS_COM_MAP b on a.company_code = b.OF_SEGMENT1_VALUE where (b.MANAGER_COM != '' or b.MANAGER_COM is not null) and length(b.MANAGER_COM) = 6 and b.MANAGER_COM not in ('863499','860000','869701','860606','860004') group by b.MANAGER_COM,a.PERIOD_NAME union select LAST_DAY(TO_DATE(a.PERIOD_NAME,'YYYY-MM')) as STATDATE, case when b.MANAGER_COM = '869701' then '860097' else b.MANAGER_COM end as COMCODE, null as COMNAME, '3' as COMLEVEL, substr(b.MANAGER_COM,1,4) as PARENT_CODE, 'KJ' as CHANNEL_CODE, '客经' as CHANNEL_NAME, sum(case when a.line_name = 'L_0-续期首年佣金' then a.actual_used_of else null END) as FIRST_FEE_A, -- 首期佣金 累计达成额 sum(case when a.line_name in ('L_0-续期聘才费用','L_0-续期基本法成本','L_0-续期展业福利费') then a.actual_used_of else null END) as FIRST_FEE_JBEN_A, -- 首期基本法 累计达成额 sum(case when a.line_name = 'L_0-续期业务费用-其中展业' then a.actual_used_of else null END) as FIRST_FEE_YWTDJY_A, -- 首期业务推动经营费用 累计达成额 sum(case when a.line_name in ('L_0-客经业务推动','L_0-客经业推专项','L_0-客经协解专项','L_0-客经人力发展','L_0-客经人发专项') then a.actual_used_of else null END) as FIRST_FEE_JL_A,-- 首期激励方案费用 累计达成额 sum(case when a.line_name = 'L_0-客经培训' then a.actual_used_of else null END) as FIRST_FEE_YWPX_A, -- 首期业务培训费用 累计达成额 sum(case when a.line_name = 'L_0-客经社保' then a.actual_used_of else null END) as FIRST_FEE_QT_A, -- 首期其他费用 累计达成额 null as FIRST_FEE_JX_A, -- 首期绩效 累计达成额 null as FIRST_FEE_SXF_A, -- 首期手续费 累计达成额 sum(case when a.line_name in ('L_0-续期首年佣金','L_0-续期聘才费用','L_0-续期基本法成本','L_0-续期展业福利费','L_0-续期业务费用-其中展业') then a.actual_used_of else null END) as FIRST_FEE_BDSJ_A from MISOPER.YGBX_REPORT_DETAILS_INTERFACE_TMP a left join MISOPER.T_SLFS_COM_MAP b on a.company_code = b.OF_SEGMENT1_VALUE where (b.MANAGER_COM != '' or b.MANAGER_COM is not null) and length(b.MANAGER_COM) = 6 and b.MANAGER_COM not in ('863499','860000','869701','860606','860004') group by b.MANAGER_COM,a.PERIOD_NAME union select LAST_DAY(TO_DATE(a.PERIOD_NAME,'YYYY-MM')) as STATDATE, case when b.MANAGER_COM = '869701' then '860097' else b.MANAGER_COM end as COMCODE, null as COMNAME, '3' as COMLEVEL, substr(b.MANAGER_COM,1,4) as PARENT_CODE, 'ZX' as CHANNEL_CODE, '振兴' as CHANNEL_NAME, sum(case when a.line_name = 'L_218-振兴首年佣金' then a.actual_used_of else null END) as FIRST_FEE_A, -- 首期佣金 累计达成额 sum(case when a.line_name = 'L_218-振兴基本法' then a.actual_used_of else null END) as FIRST_FEE_JBEN_A, -- 首期基本法 累计达成额 sum(case when a.line_name = 'L_218-振兴首期业务费用' then a.actual_used_of else null END) as FIRST_FEE_YWTDJY_A, -- 首期业务推动经营费用 累计达成额 sum(case when a.line_name in ('L_218-振兴人力发展费用','L_218-振兴专项费用小计','L_218-振兴业务推动费用') then a.actual_used_of else null END) as FIRST_FEE_JL_A, -- 首期激励方案费用 累计达成额 sum(case when a.line_name = 'L_218-振兴培训费用小计' then a.actual_used_of else null END) as FIRST_FEE_YWPX_A, -- 首期业务培训费用 累计达成额 null as FIRST_FEE_QT_A, -- 首期其他费用 累计达成额 null as FIRST_FEE_JX_A, -- 首期绩效 累计达成额 null as FIRST_FEE_SXF_A, -- 首期手续费 累计达成额 sum(case when a.line_name in ('L_218-振兴首年佣金','L_218-振兴基本法','L_218-振兴首期业务费用') then a.actual_used_of else null END) as FIRST_FEE_BDSJ_A from MISOPER.YGBX_REPORT_DETAILS_INTERFACE_TMP a left join MISOPER.T_SLFS_COM_MAP b on a.company_code = b.OF_SEGMENT1_VALUE where (b.MANAGER_COM != '' or b.MANAGER_COM is not null) and length(b.MANAGER_COM) = 6 and b.MANAGER_COM not in ('863499','860000','869701','860606','860004') group by b.MANAGER_COM,a.PERIOD_NAME union select LAST_DAY(TO_DATE(a.PERIOD_NAME,'YYYY-MM')) as STATDATE, case when b.MANAGER_COM = '869701' then '860097' else b.MANAGER_COM end as COMCODE, null as COMNAME, '3' as COMLEVEL, substr(b.MANAGER_COM,1,4) as PARENT_CODE, 'TXCJ' as CHANNEL_CODE, '团险BBC' as CHANNEL_NAME, sum(case when a.line_name = 'L_100-团险BBC首年佣金' then a.actual_used_of else null END) as FIRST_FEE_A, -- 首期佣金 累计达成额 sum(case when a.line_name = 'L_100-团险BBC人力成本' then a.actual_used_of else null END) as FIRST_FEE_JBEN_A, -- 首期基本法 累计达成额 sum(case when a.line_name in ('L_100-团险BBC业务招待费','L_100-团险BBC业务推动费用','L_100-团险BBC协解专项','L_100-团险BBC手续费(含预提)') then a.actual_used_of else null END) as FIRST_FEE_YWTDJY_A, -- 首期业务推动经营费用 累计达成额 null as FIRST_FEE_JL_A,-- 首期激励方案费用 累计达成额 null as FIRST_FEE_YWPX_A, -- 首期业务培训费用 累计达成额 null as FIRST_FEE_QT_A, -- 首期其他费用 累计达成额 null as FIRST_FEE_JX_A, -- 首期绩效 累计达成额 null as FIRST_FEE_SXF_A, -- 首期手续费 累计达成额 sum(case when a.line_name in ('L_100-团险BBC首年佣金','L_100-团险BBC人力成本','L_100-团险BBC业务招待费','L_100-团险BBC业务推动费用','L_100-团险BBC协解专项','L_100-团险BBC手续费(含预提)') then a.actual_used_of else null END) as FIRST_FEE_BDSJ_A from MISOPER.YGBX_REPORT_DETAILS_INTERFACE_TMP a left join MISOPER.T_SLFS_COM_MAP b on a.company_code = b.OF_SEGMENT1_VALUE where (b.MANAGER_COM != '' or b.MANAGER_COM is not null) and length(b.MANAGER_COM) = 6 and b.MANAGER_COM not in ('863499','860000','869701','860606','860004') group by b.MANAGER_COM,a.PERIOD_NAME union select LAST_DAY(TO_DATE(a.PERIOD_NAME,'YYYY-MM')) as STATDATE, case when b.MANAGER_COM = '869701' then '860097' else b.MANAGER_COM end as COMCODE, null as COMNAME, '3' as COMLEVEL, substr(b.MANAGER_COM,1,4) as PARENT_CODE, 'CSP' as CHANNEL_CODE, '银保CSP' as CHANNEL_NAME, sum(case when a.line_name in ('L_300-银保CSP首年佣金','L_300-银保CSP产融首年佣金') then a.actual_used_of else null END) as FIRST_FEE_A, -- 首期佣金 累计达成额 sum(case when a.line_name in ('L_300-银保CSP基本法','L_300-银保CSP产融基本法') then a.actual_used_of else null END) as FIRST_FEE_JBEN_A, -- 首期基本法 累计达成额 sum(case when a.line_name in ('L_300-银保CSP业务推动费用','L_300-银保CSP对公产融业务费用','L_300-银保CSP直营产融业务费用','L_300-银保CSP协解专项') then a.actual_used_of else null END) as FIRST_FEE_YWTDJY_A, -- 首期业务推动经营费用 累计达成额 null as FIRST_FEE_JL_A,-- 首期激励方案费用 累计达成额 null as FIRST_FEE_YWPX_A, -- 首期业务培训费用 累计达成额 null as FIRST_FEE_QT_A, -- 首期其他费用 累计达成额 null as FIRST_FEE_JX_A, -- 首期绩效 累计达成额 null as FIRST_FEE_SXF_A, -- 首期手续费 累计达成额 sum(case when a.line_name in ('L_300-银保CSP首年佣金','L_300-银保CSP产融首年佣金','L_300-银保CSP基本法','L_300-银保CSP产融基本法','L_300-银保CSP业务推动费用','L_300-银保CSP对公产融业务费用','L_300-银保CSP直营产融业务费用','L_300-银保CSP协解专项') then a.actual_used_of else null END) as FIRST_FEE_BDSJ_A from MISOPER.YGBX_REPORT_DETAILS_INTERFACE_TMP a left join MISOPER.T_SLFS_COM_MAP b on a.company_code = b.OF_SEGMENT1_VALUE where (b.MANAGER_COM != '' or b.MANAGER_COM is not null) and length(b.MANAGER_COM) = 6 and b.MANAGER_COM not in ('863499','860000','869701','860606','860004') group by b.MANAGER_COM,a.PERIOD_NAME union select LAST_DAY(TO_DATE(a.PERIOD_NAME,'YYYY-MM')) as STATDATE, case when b.MANAGER_COM = '869701' then '860097' else b.MANAGER_COM end as COMCODE, null as COMNAME, '3' as COMLEVEL, substr(b.MANAGER_COM,1,4) as PARENT_CODE, 'CT' as CHANNEL_CODE, '银保传统' as CHANNEL_NAME, null as FIRST_FEE_A, -- 首期佣金 累计达成额 sum(case when a.line_name = 'L_300-银保传统人力基本薪资' then a.actual_used_of else null END) as FIRST_FEE_JBEN_A, -- 首期基本法 累计达成额 sum(case when a.line_name in ('L_300-银保传统业务费用小计','L_300-银保专项费用汇总','L_300-银保传统满期协解专项') then a.actual_used_of else null END) as FIRST_FEE_YWTDJY_A, -- 首期业务推动经营费用 累计达成额 null as FIRST_FEE_JL_A,-- 首期激励方案费用-业务推动费用 累计达成额 null as FIRST_FEE_YWPX_A, -- 首期业务培训费用 累计达成额 null as FIRST_FEE_QT_A, -- 首期其他费用 累计达成额 sum(case when a.line_name = 'L_300-银保传统人力成本' then a.actual_used_of else null END) as FIRST_FEE_JX_A, -- 首期绩效 累计达成额 sum(case when a.line_name = 'L_300-银保传统手续费' then a.actual_used_of else null END) as FIRST_FEE_SXF_A, -- 首期手续费 累计达成额 sum(case when a.line_name in ('L_300-银保传统业务费用小计','L_300-银保专项费用汇总','L_300-银保传统满期协解专项','L_300-银保传统人力基本薪资','L_300-银保传统人力成本','L_300-银保传统手续费') then a.actual_used_of else null END) as FIRST_FEE_BDSJ_A --变动实际费用 from MISOPER.YGBX_REPORT_DETAILS_INTERFACE_TMP a left join MISOPER.T_SLFS_COM_MAP b on a.company_code = b.OF_SEGMENT1_VALUE where (b.MANAGER_COM != '' or b.MANAGER_COM is not null) and length(b.MANAGER_COM) = 6 and b.MANAGER_COM not in ('863499','860000','869701','860606','860004') group by b.MANAGER_COM,a.PERIOD_NAME union select LAST_DAY(TO_DATE(a.PERIOD_NAME,'YYYY-MM')) as STATDATE, case when b.MANAGER_COM = '869701' then '860097' else b.MANAGER_COM end as COMCODE, null as COMNAME, '3' as COMLEVEL, substr(b.MANAGER_COM,1,4) as PARENT_CODE, 'JD' as CHANNEL_CODE, '经代' as CHANNEL_NAME, null as FIRST_FEE_A, -- 首期佣金 累计达成额 null as FIRST_FEE_JBEN_A, -- 首期基本法 累计达成额 sum(case when a.line_name in ('L_500-经代业务费用','L_500-经代预提') then a.actual_used_of else null END) as FIRST_FEE_YWTDJY_A, -- 首期业务推动经营费用 累计达成额 null as FIRST_FEE_JL_A,-- 首期激励方案费用-业务推动费用 累计达成额 null as FIRST_FEE_YWPX_A, -- 首期业务培训费用 累计达成额 null as FIRST_FEE_QT_A, -- 首期其他费用 累计达成额 null as FIRST_FEE_JX_A, -- 首期绩效 累计达成额 sum(case when a.line_name = 'L_500-经代手续费' then a.actual_used_of else null END) as FIRST_FEE_SXF_A, -- 首期手续费 累计达成额 sum(case when a.line_name in ('L_500-经代业务费用','L_500-经代预提','L_500-经代手续费') then a.actual_used_of else null END) as FIRST_FEE_BDSJ_A --变动实际费用 from MISOPER.YGBX_REPORT_DETAILS_INTERFACE_TMP a left join MISOPER.T_SLFS_COM_MAP b on a.company_code = b.OF_SEGMENT1_VALUE where (b.MANAGER_COM != '' or b.MANAGER_COM is not null) and length(b.MANAGER_COM) = 6 and b.MANAGER_COM not in ('863499','860000','869701','860606','860004') group by b.MANAGER_COM,a.PERIOD_NAME
09-16
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值