电子专票和纸质专票初次核定份数合计超过25份的户数占比.docx

电子专票和纸质专票初次核定份数合计超过25份的户数占比SE1.ECTNSRMCas纳税人名称，nvl(SHXYDM,NSRSBH)as社会信用代码，nsrdzdahas纳税人电子档案号，Swjgmcas主管税务机关，swryas税收管理员，fpzmcas发票种类，Myzggpslas每月最高购票数量，YXQQas有效期起，YXQZas有效期止，Irrqas录入日期，dsswjgmcas地市级税务机关，q×swjgmcas区县级税务机关FROM(SE1.ECTHDQCXH,A.NSRDZDAHzSHXYDM,NSRSBH,NSRMC,B.FPZ1.mc,Aqffpzgkpxejd,a.dffpzgkpxeMYZGGPS1.,MCZGGPS1.zYXQQ,YXQZ,NSR.SWJG_DM,NSR.SSG1.YSWRY_DM,nsr.ssglyswrymcswry,nsr.swjgme,nsr.dsswjg_dm,nsr.dsswjgmc,nsr.qxswjgmc,A.1.RRQ,B.ZPPZJD,SM(MYZGGPS1.)OVER(PARTITIONBYA.NSRDZDAH,1.RRQ)MYZGGPS1._HZ,RANK()OVER(PARTITIONBYA.NSRDZDAHORDERBYA.1.RRQ)ASRID,-202203231.IJYMIN(YXQQ)OVER(PARTITIONBYA.NSRDZDAH,1.RRQ)M_YXQQ-202203231.IJYFROMSJCK_BZ.FP_PZHDXXAINNERJOINSJCK_BZ.WD_FPZ1.BONA.FPZ1._ID=B.FPZ1._IDINNERJOIN(SE1.ECTNSR.NSRDZDAH,NSR.SWJGJD,NSR.SWJG_DM,NSR.SSGIYSWRY_DM,NSR.swjgmc,nsr.dsswjg_dmznsr.dsswjgmc,nsr.ssglyswrymc,nsr.qxswjgmcFROMSJCK_BZ.WD_NSRXXNSRwhereNSR.kqccsztdjBZ=,n,ANDNSR.KZZTDJ1.XJD<,1140,ANDNSR.NSRZT1.XJDISNU1.1.ANDNSR.NSRZT_DM='03'ANDNSR.YXBZ='Y,ANDTRUNC(NSR.SWHZDJRQ)>=(selectCASEWHENCOUNT(I)>=1THENDAE,2018-10-01,E1.SEDAE,2018-08-01,ENDDATE_1.RRQfromWD_SWJGwherejGJCJD='OANDSWJGCC1.X_BJ=,1,ANDSWJGJDIN(,16300000000,z,15400000000,16500000000')NSRONA.NSRDZDAH=NSR.NSRDZDAHWHEREB.ZPPZ_IDIN(,1,9')ANDA.YXQZ>A.YXQQ)TWHERET.RID=1ANDT.1.RRQ>=(selectCASEWHENCOUNT(I)>=1THENDAE'2018-10-01'E1.SEDAE,2018-08-01'ENDDArE_1.RRQfromWD_SWJGWherejGJCJD=1Ol'ANDSWJGCC1.X_BJ=TANDSWJG_IDIN('16300000000,15400000000,16500000000,)-20220318/XYIMAND*T.YXQQ*M-YXQQ>=fxqjq-202203231.IJYAND*T.YXQQ*M-YXQQ<trunc(sysdate)-202203231.IJYANDMYZGGPS1._HZ>25andt.dsswjg_dm=dsswjg_dm;