FOR patologie IN (
      SELECT P.NOME AS NOME, COUNT(*) AS N_DIAGNOSI
      FROM PATOLOGIA P, DIAGNOSI D, VISITA V, TURNO_MEDICO TM, AMBULATORIO AM
      WHERE P.ID_PATO LIKE D.ID_PATO
      AND V.TURNO LIKE TM.ID_TURNO
      AND TM.AMB LIKE AM.ID_AMB
      AND V.ID_VISITA LIKE D.ID_VISITA
      AND AM.CENTRO_SANITARIO LIKE (STUD_PATOLOGIE.ID_CENTRO)
      AND TM.INIZIO BETWEEN '01-JUN-18 10:00:00,000000000' AND '22-JUN-18 10:00:00,000000000'
      GROUP BY P.NOME
      HAVING COUNT(*) LIKE (SELECT MAX(RIS.N_DIAGNOSI)
      FROM (SELECT P.NOME, COUNT(*) AS N_DIAGNOSI
      FROM PATOLOGIA P, DIAGNOSI D, VISITA V, TURNO_MEDICO TM, AMBULATORIO AM
      WHERE P.ID_PATO LIKE D.ID_PATO
      AND V.ID_VISITA = D.ID_VISITA
      AND V.TURNO LIKE TM.ID_TURNO
      AND TM.AMB LIKE AM.ID_AMB
      AND AM.CENTRO_SANITARIO LIKE (STUD_PATOLOGIE.ID_CENTRO)
      AND TM.INIZIO BETWEEN '01-JUN-18 10:00:00,000000000' AND '22-JUN-18 10:00:00,000000000'
      GROUP BY P.NOME) RIS)
    )
    LOOP
      gui.apririgatabella;
      gui.creacellatabella(patologie.NOME);
      gui.creacellatabella(patologie.N_DIAGNOSI);
      gui.apricellatabella;
      gui.aggiungiBottone(mName => 'INFO',mValue => 'INFO',eventJS => 'onclick',scriptJS => 'alert(''ciao'');');
      gui.chiudicellatabella;
      gui.chiudirigatabella;
    END LOOP;