SELECT ROWNUM progressivo_quest, lau.*
  FROM (  SELECT p01_anaper.cod_fis cod_fiscale_lau,
                 p01_anaper.cognome cognome_lau,
                 p01_anaper.nome nome_lau,
                 p01_anaper.sesso sesso_lau,
                 p01_cittad.citt_cod cod_cittadinanza_lau,
                 tipi_corso.id_tipo_laurea tipo_laurea_lau,
                 p07_cla_murst.classe_miur_id classe_laurea_lau,
                 p06_cds.des descrizione_corso_lau,
                 p01_anaper.via_res || ' ' || NVL (p01_anaper.num_civ_res, '')
                    indirizzo_lau,
                 DECODE (p01_anaper.naz_res_id, 1, prov_res.cod, 'EE')
                    cod_provincia_lau,
                 DECODE (p01_anaper.naz_res_id,
                         1, SUBSTR (COMU_RES.COD_ISTAT, 4, 3),
                         '999')
                    cod_comune_lau,
                 p01_anaper.cap_res cap_lau,
                 NULL prefisso_1_lau,
                 p01_anaper.tel_res telefono_1_lau,
                 NULL prefisso_2_lau,
                 p01_anaper.tel_dom telefono_2_lau,
                 NULL prefisso_cell_lau,
                 p01_anaper.cellulare telefono_cell_lau,
                 p01_anaper.email_ate email_1_lau,
                 NVL (p01_anaper.email_certificata, p01_anaper.email)
                    email_2_lau
            FROM p07_cla_murst,
                 p07_cla_ateneo,
                 p06_cla_cds,
                 p06_cds,
                 tipi_corso,
                 p04_mat,
                 p01_cittad,
                 p01_prov prov_res,
                 p01_comu comu_res,
                 p01_anaper,
                 p01_stu,
                 p12_dom_ct
           WHERE     p06_cds.tipo_corso_cod = tipi_corso.tipo_corso_cod
                 AND p07_cla_ateneo.cla_m_id = p07_cla_murst.cla_m_id(+)
                 AND p06_cla_cds.cla_a_id = p07_cla_ateneo.cla_a_id(+)
                 AND p06_cds.cds_id = p06_cla_cds.cds_id(+)
                 AND tipi_corso.id_tipo_laurea IS NOT NULL
                 AND p04_mat.cds_id = p06_cds.cds_id
                 AND p01_anaper.citt1_cod = p01_cittad.citt_cod(+)
                 AND comu_res.sigla = prov_res.sigla(+)
                 AND p01_anaper.com_res_id = comu_res.comune_id(+)
                 AND p01_stu.pers_id = p01_anaper.pers_id
                 AND p04_mat.sta_mat_cod = 'A'
                 AND p01_stu.stu_id = p04_mat.stu_id
                 AND p12_dom_ct.stato = 'CHI'
                 AND p12_dom_ct.stu_id = p01_stu.stu_id
                 AND tipi_corso.id_tipo_laurea IN
                        ('LM', 'TU', 'LS', 'LT', 'MS', 'LV')
                 AND p12_dom_ct.data_ct BETWEEN TO_DATE ('01/01/2011',
                                                         'DD/MM/YYYY')
                                            AND TO_DATE ('31/12/2011',
                                                         'DD/MM/YYYY')
        ORDER BY p01_anaper.cognome, p01_anaper.nome) lau