#Cantidad por día de 'Se envia service'
SELECT xmmdd , (COUNT(*)) AS registros FROM pruebadb WHERE  tabulacion4 = 'Se envia service' GROUP BY xmmdd ORDER BY xmmdd DESC;

#Cantidad total de 'Se envia service'
SELECT (COUNT(*)) AS registros FROM pruebadb WHERE  tabulacion4 = 'Se envia service' ORDER BY xmmdd DESC;

#Detalle de cada cosa por día
SELECT tabulacion1, tabulacion2, tabulacion3, xmmdd FROM pruebadb WHERE tabulacion4 = 'Se envia service' ORDER BY xmmdd DESC;

#Detalle por día específico
SELECT tabulacion1, tabulacion2, tabulacion3 FROM pruebadb WHERE tabulacion4 = 'Se envia service' AND xmmdd = '618';