Consulta HDN.sql

SET DateStyle TO DMY;

SELECT 
	historia, 
	COUNT(DISTINCT(historia)) AS veces, 
	SUBSTRING(edad,1,2) AS edad, 
	DATE_PART('day', fecing::TIMESTAMP - fecisn::TIMESTAMP) AS estancia, 
	sexo, 
	SUBSTRING(procprov, '-  *([A-Z, ]{1,15})') AS departamento
	
FROM hospital
WHERE historia <> '0'
GROUP BY historia, edad, fecing, fecisn, sexo, procprov
ORDER BY historia ASC