SELECT proposal_id, AVG(total_score) AS avg_score FROM (SELECT r.proposal_id, SUM(rs.value) AS total_score FROM opas_review r INNER JOIN opas_review_score rs USING (review_id) GROUP BY r.review_id) AS t1 GROUP BY proposal_id ORDER BY avg_score;