UPDATE
    scores
SET
    passed = (CASE
        WHEN 
WHERE
    (
    SELECT
        subject_code,
        AVG(score) OVER(PARTITION BY subject_code ORDER BY subject_code)
    FROM
        scores
    GROUP BY
        subject_code
    )



SELECT
    *
FROM
    scores;