2017-08-11 - AD - Apagando avaliações para Janaina

// Regina
select a.NOME, a.CODAVALIACAO, p.CHAPAAVALIADO, p.CODPARTICIPANTE from participantes as p
inner join avaliacoes as a on a.CODCOLIGADA = p.CODCOLIGADA and a.CODAVALIACAO = p.CODAVALIACAO
where CHAPAAVALIADO = 110320

//Gardenia

select a.NOME, a.CODAVALIACAO, p.CHAPAAVALIADO, p.CODPARTICIPANTE from participantes as p
inner join avaliacoes as a on a.CODCOLIGADA = p.CODCOLIGADA and a.CODAVALIACAO = p.CODAVALIACAO
where CHAPAAVALIADO = 110540

//regina
select * from notas where CODPARTICIPANTE = 60313 and CODAVALIACAO = 25

//gardenia
select * from notas where CODPARTICIPANTE = 60437 and CODAVALIACAO = 25

// lilia 

select a.NOME, a.CODAVALIACAO, p.CHAPAAVALIADO, p.CODPARTICIPANTE from participantes as p
inner join avaliacoes as a on a.CODCOLIGADA = p.CODCOLIGADA and a.CODAVALIACAO = p.CODAVALIACAO
where CHAPAAVALIADO = 110457

select * from notas where CODPARTICIPANTE = 61510 and CODAVALIACAO = 26