SQL - Ayuda con consula sql

Select c.CandidateId, u.FirstName, u.LastName, c.QuantityVotes, g.Description

from Users u

inner join Candidates c

on u.UserId = c.UserId

inner join Votings v

on c.VotingId = v.VotingId

inner join VotingGroup vg

on  v.VotingId = vg.VotingId

inner join Groups g

on vg.GroupId = g.GroupId

where g.GroupId = 1

and v.VotingId = 1;

-- CANDIDATOS Y FACULTAD

WITH candidatos AS (

    SELECT cc.candidateid AS candidatoid, u.lastname AS candidatonombre, u.firstname AS candidatoapellido, g.description AS facultad

        FROM candidates AS cc

            INNER JOIN users AS u ON u.userid = cc.userid

            INNER JOIN groupmembers as gm ON gm.userid = u.user_id

            INNER JOIN groups as g ON g.groupid = gm.groupid

),

-- VOTOS POR CANDIDATO

votos AS (

    SELECT cc.candidateid AS candidatoid, v.quantityvotes cantidadvotos, v.quantityblankvotes AS cantidadvotosblancos

        FROM candidates AS cc

            INNER JOIN votings AS v ON v.votingid = cc.votingid

            INNER JOIN votinggroup AS vg ON vg.votingid = v.votingid

            -- INNER JOIN groups as g ON g.groupid = vg.groupid

)

-- VOTOS POR CANDIDATO FACULTAD

SELECT c.facultad, c.candidatonombre, c.candidatoapellido, SUM(v.cantidadvotos) totalvotos, SUM(v.cantidadvotosblancos) totalvotosblancos

    FROM candidatos AS c

    INNER JOIN votos AS v ON v.candidatoid = c.candidatoid

    GROUP BY c.facultad, c.candidatonombre, c.candidatoapellido

    ORDERY SUM(v.cantidadvotos) DESC