#Volumetria Recibidos
SELECT c.FFRMS_1BC56B80, `Grupo`,`Año`,CFDIS_RECIBIDOS
FROM
(
SELECT 
       A.FFRMS_0F5BE219 AS `Empresa`,     
       B8.FFRMS_0F196048 AS `Grupo`,
       DATE_FORMAT(FFRMS_A91614A5,'%Y') AS `Año`,
       COUNT(*) AS CFDIS_RECIBIDOS
FROM SI_FORMS_BAPPE4E3720E_FRM_ABD59F43 A
LEFT JOIN SI_FORMS_BAPPE4E3720E_FRM_BD28A6F6 B8 ON B8.id_FRM_BD28A6F6 = A.FFRMS_61B8300E
#where FFRMS_9621E305='CORPORATE SOLUTIONS MEXICO SA DE CV'
WHERE B8.FFRMS_0F196048='KHS'
GROUP BY A.FFRMS_0F5BE219, B8.FFRMS_0F196048,DATE_FORMAT(FFRMS_A91614A5,'%Y')
)
paso
JOIN si_forms_bappe4e3720e_frm_5e94d67d C ON C.id_frm_5e94d67d=paso.Empresa
;

#Volumetria emitidos
SELECT c.FFRMS_1BC56B80 AS Empresa, `Grupo`,`Año`,CFDIS_Emitidos
FROM
(
SELECT 
	B8.FFRMS_0F196048 AS `Grupo`,       
       A.FFRMS_42176F5E AS `Empresa`,     
       DATE_FORMAT(FFRMS_3714CB90,'%Y') AS `Año`,
       COUNT(*) AS CFDIS_Emitidos
FROM SI_FORMS_BAPPE4E3720E_FRM_76AA7E89 A
LEFT JOIN SI_FORMS_BAPPE4E3720E_FRM_BD28A6F6 B8 ON B8.id_FRM_BD28A6F6 = A.FFRMS_4A341B4C
#where FFRMS_9621E305='CORPORATE SOLUTIONS MEXICO SA DE CV'
WHERE B8.FFRMS_0F196048='KHS'
GROUP BY A.FFRMS_42176F5E, B8.FFRMS_0F196048,DATE_FORMAT(FFRMS_3714CB90,'%Y')
)
paso
JOIN si_forms_bappe4e3720e_frm_5e94d67d C ON C.id_frm_5e94d67d=paso.Empresa
;
#Volumetria nomina
SELECT B8.FFRMS_0F196048 AS Grupo,FFRMS_0F196048 AS Empresa,DATE_FORMAT(FFRMS_AAF14390,'%Y') AS `Año`, COUNT(*) 
FROM SI_FORMS_BAPPE4E3720E_FRM_3658DAAE A
LEFT JOIN SI_FORMS_BAPPE4E3720E_FRM_BD28A6F6 B8 ON B8.id_FRM_BD28A6F6 = A.FFRMS_CCF837CD
WHERE B8.FFRMS_0F196048='KHS'
GROUP BY B8.FFRMS_0F196048,FFRMS_0F196048,DATE_FORMAT(FFRMS_AAF14390,'%Y')
;
#SAT CFDIS PAGOS PROVEEDORES DETALLE
SELECT B8.FFRMS_0F196048 AS Grupo,FFRMS_80999406 AS Empresa,DATE_FORMAT(FFRMS_49BD3EF7,'%Y') AS `Año`, COUNT(*) 
FROM SI_FORMS_BAPPE4E3720E_FRM_1C5F9D81 A
LEFT JOIN SI_FORMS_BAPPE4E3720E_FRM_BD28A6F6 B8 ON B8.id_FRM_BD28A6F6 = A.FFRMS_07E878B1
WHERE B8.FFRMS_0F196048='KHS'
GROUP BY B8.FFRMS_0F196048,FFRMS_80999406,DATE_FORMAT(FFRMS_49BD3EF7,'%Y')
;
#SAT CFDI PAGOS CLIENTES
SELECT B8.FFRMS_0F196048 AS Grupo,FFRMS_8D1148C5 AS Empresa,DATE_FORMAT(FFRMS_C32FBE45,'%Y') AS `Año`, COUNT(*) 
FROM SI_FORMS_BAPPE4E3720E_FRM_D12BC51F A
LEFT JOIN SI_FORMS_BAPPE4E3720E_FRM_BD28A6F6 B8 ON B8.id_FRM_BD28A6F6 = A.FFRMS_16F37FDC
WHERE B8.FFRMS_0F196048='KHS'
GROUP BY B8.FFRMS_0F196048,FFRMS_8D1148C5,DATE_FORMAT(FFRMS_C32FBE45,'%Y')
;