p39 6T

//实现 6-50之间的偶数表示成两个素数 
#include <stdio.h> 
main()
{
	int i,j,m,n;
	for(m=6;m<=50;m+=2)//m为6-50之间的偶数 
		for(n=2;n<m;n++) //n为2-m之间的整数 
		{
			for(i=2;n%i!=0;i++);
				if(n==i)
				{
					for(j=2;(m-n)%j!=0;j++);
					if(m-n==j)
					{
						printf("%d=%d+%d\n",m,n,m-n);
						break;
					} 
				}
		}
}

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
SELECT d.areaCode, d.areaName, d.bciStreetName, d.wasteTypeCode, d.wasteTypeName, d.wasteTrashCode, d.wasteTrashName, d.wasteName, sum( p.produceNumTotal ) AS produceNumTotal, sum( IFNULL(t.disposalNumTotal, 0 ),decimal(10,2) ) AS disposalNumTotal, sum( p.cityTransferNum ) AS cityTransferNum, sum( p.transferCityOutNum ) AS transferCityOutNum, sum( p.transferProvinceOutNum ) AS transferProvinceOutNum, sum( IFNULL( p.transferCityOutNum, 0 ) + IFNULL( p.transferProvinceOutNum, 0 ) ) AS transferCityAndProInNum, sum( t.transferCityInNum ) AS transferCityInNum, sum( t.transferProvinceInNum ) AS transferProvinceInNum, sum( IFNULL( t.transferCityInNum, 0 ) + IFNULL( t.transferProvinceInNum, 0 ) ) AS transferCityAndProInNum, sum( d.disposalAmount ) AS disposalAmount, sum( d.zhlyAmount ) AS zhlyAmount, sum( d.czAmount ) AS czAmount, sum( d.zcAmount ) AS zcAmount, sum( d.tmAmount ) AS tmAmount, sum( d.fsAmount ) AS fsAmount, sum( d.qtAmount ) AS qtAmount, CONVERT ( sum( zhlyAmount ) / sum( d.disposalAmount ) * 100, DECIMAL ( 10, 2 ) ) AS zhlyProportion, CONVERT ( sum( tmAmount ) / sum( d.disposalAmount ) * 100, DECIMAL ( 10, 2 ) ) AS tmProportion, CONVERT ( sum( fsAmount ) / sum( d.disposalAmount ) * 100, DECIMAL ( 10, 2 ) ) AS fsProportion, CONVERT ( sum( qtAmount ) / sum( d.disposalAmount ) * 100, DECIMAL ( 10, 2 ) ) AS qtProportion FROM wfcs_disposal_account_day_report d LEFT OUTER JOIN wfcs_transfer_sheet_disposal_day_summary t ON d.cityCode = t.disposalCityCode AND t.tenantId = d.tenantId LEFT OUTER JOIN wfcs_transfer_sheet_produce_day_summary p ON d.cityCode = p.produceCityCode AND d.tenantId = p.tenantId WHERE d.solidWasteType ='ybgygf' AND d.tenantId = '779ca469251e4a639fd39a7ab57e6859' AND d.recordDate >= '2023-06-01 00:00:00.0' AND d.recordDate <= '2023-06-04 00:00:00.0' AND d.cityCode = 'dacef933e39740349e6fb89fac792aae' GROUP BY areaCode ORDER BY produceNumTotal DESC 怎么优化这个sql
06-06

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值