presencas

SELECT nome,
       cpf,
       sum(qtd_periodo1) as qtd_periodo1,
       sum(qtd_periodo2) as qtd_periodo2,
       sum(qtd_periodo3) as qtd_periodo3,
       sum(qtd_periodo4) as qtd_periodo4,
       sum(qtd_periodo5) as qtd_periodo5,
       sum(qtd_periodo6) as qtd_periodo6,
       sum(qtd_periodo7) as qtd_periodo7
  FROM (SELECT cae.caenome as nome,
               cae.caecpf as cpf,
               (SELECT SUM(frq.frqqtdpresenca) WHERE prc.perid = 1) as qtd_periodo1,
               (SELECT SUM(frq.frqqtdpresenca) WHERE prc.perid = 2) as qtd_periodo2,
               (SELECT SUM(frq.frqqtdpresenca) WHERE prc.perid = 3) as qtd_periodo3,
               (SELECT SUM(frq.frqqtdpresenca) WHERE prc.perid = 4) as qtd_periodo4,
               (SELECT SUM(frq.frqqtdpresenca) WHERE prc.perid = 5) as qtd_periodo5,
               (SELECT SUM(frq.frqqtdpresenca) WHERE prc.perid = 6) as qtd_periodo6,
               (SELECT SUM(frq.frqqtdpresenca) WHERE prc.perid = 7) as qtd_periodo7
          FROM projovemurbano.cadastroestudante cae
            INNER JOIN projovemurbano.frequenciaestudante frq ON frq.caeid = cae.caeid
            INNER JOIN projovemurbano.diariofrequencia dif ON dif.difid = frq.difid
            INNER JOIN projovemurbano.diario dia ON dia.diaid = dif.diaid
            INNER JOIN projovemurbano.periodocurso prc USING(perid)
          WHERE cae.caeid = 44327
          GROUP BY cae.caenome,
                   cae.caecpf,
                   prc.perid) somatoria
  GROUP BY nome,
           cpf