with ranked_predictions as (    select         id,         prediction,         probability,        row_number() over(partition by id order by probability desc) as rn    from iris_predictions)select    p.id,    a.species as actual,    p.prediction,    p.probability,    case        when a.species = p.prediction then 1        else 0    end as is_correctfrom ranked_predictions pjoin v_iris_test a on a.id = p.idwhere p.rn = 1;