怎么样 SELECT Department, Studavailability, COUNT(*) FROM students GROUP BY Department, Studavailability; ? 祝你好运！

首先你得数数 department,studavailablity 在子查询上。然后使用 GROUP_CONCAT 函数创建studcountby子查询。
如果你想展示 Yes 在前面 No 你可以加上 order by 在 GROUP_CONCAT 功能。
你可以试试这个。

SELECT department,GROUP_CONCAT(Concat(studavailablity,' ',c) order by 1 DESC)  'count'
FROM(
  SELECT count(1) c,department,studavailablity 
  FROM T
  GROUP BY studavailablity,department
) t
group by department
order by department desc

sqlfiddle:http：//sqlfiddle.com/#！2016年9月4日