sql 对于阶段

select '无' AS label,count(*) AS value from tbl_person_employment_info where nsr is null
						union all
            select '2万以下的' AS label,count(*) AS value from tbl_person_employment_info where nsr = '1'
            union all
            select '2万-5万的' AS label,count(*) AS value from tbl_person_employment_info where nsr = '2'
            union all
            select '5万-10万的' AS label,count(*) AS value from tbl_person_employment_info where nsr = '3'
            union all
            select '10万以上' AS label,count(*) AS value from tbl_person_employment_info where nsr in ('4','5','6')