select top 5 c_name,c_stu from class where c_stu>30 and c_type=true and c_name like '*二班*' order by c_stu asc,c_type desc
Like 后 用'%二班%'
c_type='ture'c_name like'%二班%'count的值35