select * from tb where not exists
select * from tb where xz in ('公共选修课','专业选修课') and (cj > 60  or cj in('优秀','良好'))

------解决方案--------------------

SQL code

select * from tb 
where xz not in ('公共选修课','专业选修课') 
    or (xz in ('公共选修课','专业选修课') 
            and (cj<>'不及格'
                    or (cj>=60 and isnumeric(cj)=1)
                 )
        )