Hello

I have a table based on an SQL query. Although, data are presented fine, there is no option of filtering, which does not produce any results.

Here follows the SQL query:

SELECT 
      hospital as 'Hospital_name',
      COUNT(*)        
          as 'Aortic Aneurysm Disease',
      (          
      SELECT COUNT(*)        
          FROM registry_aortic_aneurysm_disease 
          WHERE hospital = Hospital_name AND date_of_treatment >= '2020-01-01 00:00:00' 
          AND date_of_treatment < '2021-01-01 00:00:00'
          AND (location='Infrarenal' OR location='Iliac')
          ) as 'Infrarenal',

(          
      SELECT COUNT(*)        
          FROM registry_aortic_aneurysm_disease 
          WHERE hospital = Hospital_name AND date_of_treatment >= '2020-01-01 00:00:00' 
          AND date_of_treatment < '2021-01-01 00:00:00'
          AND (location='Infrarenal' OR location='Iliac')
          AND clinical_condition='Asymptomatic'
          ) as 'Infrarenal Asymptomatic',

(          
      SELECT COUNT(*)        
          FROM registry_aortic_aneurysm_disease 
          WHERE hospital = Hospital_name AND date_of_treatment >= '2020-01-01 00:00:00' 
          AND date_of_treatment < '2021-01-01 00:00:00'
          AND (location='Infrarenal' OR location='Iliac')
          AND clinical_condition!='Asymptomatic'
          ) as 'Infrarenal Symptomatic (incl Ruptured)',

      (          
      SELECT COUNT(*)        
          FROM registry_aortic_aneurysm_disease 
          WHERE hospital = Hospital_name AND date_of_treatment >= '2020-01-01 00:00:00' 
          AND date_of_treatment < '2021-01-01 00:00:00'
          AND location!='Infrarenal'
          ) as 'Not infrarenal' 

FROM registry_aortic_aneurysm_disease WHERE date_of_treatment >= '2020-01-01 00:00:00' AND date_of_treatment < '2021-01-01 00:00:00'
GROUP BY Hospital_name

Any help would be much appreciated.

Kind regards, and a Happy New Year

Andreas