This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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 |