Mysql query for getting count as per two grouping condition

Question

I have below data table and need to accomplish the result for Student count as per availability and per department

Note: Different Department may come in later.

Updated: Department Table:

Want to have result as below: (Student count as per availability and per department)

Possible duplicate of [MySQL "Group By" and "Order By"](https://stackoverflow.com/questions/1066453/mysql-group-by-and-order-by) — jose_bacoy, Apr 20 '18 at 01:10
SELECT DISTINCT tblDept.DeptName, count(studid) FROM tblDept,tblStud where tblDept.DeptName= tblStud.DeptName group by tblDept.DeptName , this is only getting me the department wise final count, but i want to have the count as per the availability and department — usr021986, Apr 20 '18 at 01:13
I needed to get two parameters in the groupby.. i was giving only one.... I have got the desired result — usr021986, Apr 20 '18 at 01:18

score 0 · Answer 1 · answered Apr 20 '18 at 01:14

0

Maybe this could work,

SELECT Department, 
       CONCAT(Studavailability,', ',
              COUNT(*)) 
       as "Stud Count as per availability per department"
FROM Table
Group By Department, Studavailability

answered Apr 20 '18 at 01:14

wookiekim

1,156
7
20

Mysql query for getting count as per two grouping condition

1 Answers1