1
How to pass a CTE in SQL for relational algebra, for example:
with publicacao_cte (nome,nr_publicacoes)
AS
(
select
candidato.nome,
Count(1) as nr_publicacoes
from
candidato,
cv,
ficha_inscricao,
publicacao_cv
where
candidato.bi = ficha_inscricao.bi and
candidato.bi = cv.bi and
cv.cod_cv = publicacao_cv.cod_cv
group by candidato.nome
)
I’d also like to know how to do the group by
and order by
in relational algebra.