-- alcanceTotalesGeneral
SELECT
    (SELECT COUNT(*) FROM MEDICOS)                          AS 'Médicos',
    (SELECT COUNT(*) FROM CLINICA)                          AS 'Clínicas'

-- alcanceTotalesExpedientes
SELECT
    (SELECT COUNT(*) FROM PACIENTE)                         AS 'Pacientes',
    (SELECT COUNT(*) FROM NOTAS_EVOLUCION)                  AS 'Notas de evolución',
    (SELECT COUNT(*) FROM NOTAS_ADICIONALES)                AS 'Notas adicionales',
    (SELECT COUNT(*) FROM RECETAS)                          AS 'Recetas',
    (SELECT COUNT(*) FROM ANALISIS_CLINICOS_ENC)            AS 'Órdenes de análisis clínicos',
    (SELECT COUNT(*) FROM ESTUDIOS_GABINETE_ENC)            AS 'Órdenes de estudios de gabinete',
    (SELECT COUNT(*) FROM REGISTROS_CRECIMIENTO)            AS 'Registros de crecimiento',
    (SELECT COUNT(*) FROM REGISTROS_PRENATAL)               AS 'Registros prenatales',
    (SELECT COUNT(*) FROM REGISTROS_VACUNAS) +
    (SELECT COUNT(*) FROM OTRAS_VACUNAS)                    AS 'Vacunas',
    (SELECT COUNT(*) FROM FOTOS)                            AS 'Imágenes',
    (SELECT COUNT(*) FROM DOCUMENTOS)                       AS 'Documentos',
    (SELECT COUNT(*) FROM ENLACES_EXTERNOS)                 AS 'Enlaces externos',
    (SELECT COUNT(*) FROM HC_POR_FECHA)                     AS 'Historias clínicas',
    (SELECT COUNT(*) FROM DOC_FORMATOS)                     AS 'Formatos'

-- alcanceTotalesCaja
SELECT
    (SELECT COUNT(*) FROM CARGOS)                           AS 'Cargos',
    (SELECT COUNT(*) FROM ABONOSENC)                        AS 'Abonos',
    (SELECT COUNT(*) FROM COTIZACIONES)                     AS 'Cotizaciones'

-- alcanceTotalesAgenda
SELECT
    (SELECT COUNT(*) FROM D_AGENDA)                         AS 'Citas',
    (SELECT COUNT(*) FROM A_MEDICOFECHANOLABORABLE)         AS 'Otros eventos',
    (SELECT COUNT(*) FROM CITAS_CONTROL)                    AS 'Citas de control'
