luiscauro

-- Query Conteo
SELECT
  (SELECT count(1) FROM sch_pbl.maq_casino where estado = 'E') HAB, -- Habilitadas
  (SELECT count(1) FROM sch_pbl.maq_casino where estado = 'E' AND coljuego = 'E') HAB_ENV, -- Habilitadas enviado
  (SELECT count(1) FROM sch_pbl.maq_casino where estado = 'D' AND coljuego = 'E') DESH_ENV, -- Deshabilitadas Enviados
  (SELECT count(1) FROM sch_pbl.maq_casino where estado = 'E' AND numero_serie IS NULL ) N_SERIE_NULL, -- Numero de Serie NO NULL
  (SELECT count(1) FROM sch_pbl.maq_casino where estado = 'E' AND nuid IS NULL ) NUID_NULL, -- Nuid NO NULL
  (SELECT count(1) FROM sch_pbl.maq_casino where estado = 'E' AND porcentaje_teorico IS NULL ) Porcentaje_NULL, -- Porcentaje Teorico NO NULL
  (SELECT count(DISTINCT(cod_dgjcmt)) FROM sch_pbl.maq_casino where estado = 'E' ) NUC_DISTINTOS, -- Nuc que no se Repiten
  (SELECT count(1) FROM sch_pbl.maq_casino where estado = 'E' AND octet_length(cod_dgjcmt) >= 10 ) NUC_Mayor_10Char; -- Nuc mayores a 10 Dig