Given the following two SQL operations:
select prod_Id, P.proposal_id, P.institution_Name
from proposals P
group by P.proposal_ID
having mark >= 50
order by P.proposal_id desc
select prod_id, P.proposal_id, PA.evaluator_ID, U.user_Given_Name, U.user_surname
from users U, proposals P
LEFT outer JOIN proposal_appraisal PA
ON (P.proposal_Id = PA.proposal_id)
where PA.evaluator_ID = U.user_id
group by prod_id, PA.evaluator_ID
order by PA.proposal_ID, U.user_ID desc
How to modify the following SQL operation so that prod_Id will be selected in addition to the existing columns being selected:
select PA.proposal_id, PA.evaluator_ID, PA.Primary_Evaluation_Status_ID, PA.Secondary_Evaluation_Status_ID, U.user_Given_Name, U.user_surname,
from users U, proposal_appraisal PA
where PA.evaluator_ID = U.user_id
group by PA.proposal_id, PA.evaluator_ID
order by PA.proposal_ID, U.user_ID desc