Hii Guyz,I am having this little problem creating a query in MySQL.Problem description:Table: mytableTable Structure:IssueId | ToolName | Status01 | Tool1 | Open02 | Tool1 | Closed03 | Tool2 | Closed04 | Tool3 | OpenNow, I want to get the results in the following form:ToolName | Count(Open) | Count(Closed)For the above input, result will be:Tool1 | 1 | 1Tool2 | 0 | 1Tool3 | 1 | 0There should be NO duplicate toolName in output.Thnaks,Manu.