select g.stu_no,g.subject_name,gra= (case when r_no>50 then 50
                                             else r_no end) +
                                     (case when t_no>50 then 50
                                             else r_no end)
    from grade g inner join forum m on g.stu_no=m.stu_no