通过学院或年级或专业或班级获取民族人数

通过学院或年级或专业或班级获取民族人数

  SELECT
	nationality,
	count(*) as statistics
FROM
	st_student
WHERE
	college = #{college}
        <if test="fieldTwo !=null and fieldTwo!=''">
        AND field_two = #{fieldTwo}
        </if>
        <if test="profession !=null and profession!=''">
            and profession = #{profession}
        </if>
        <if test="stClass !=null  and stClass!=''">
            AND st_class  = #{stClass}
        </if>
GROUP BY
	nationality
    </select>