select  ROW_NUMBER() OVER (ORDER BY p.CodPersona) AS Numero,
    ccc.Descripcion     AS      Curso,
    p.CodPersona        AS      Codigo,
    p.NombreCompleto    AS      NombreAlumno,
    cc.Detalle          AS      Detalle,
    SUM(cc.Valor)       AS      Valor

where cc.Detalle is not null
    and cc.Valor != 0.00

    group by cc.Detalle,
        ccc.Descripcion,
        p.CodPersona,
        p.NombreCompleto