Try this:
SELECT CONCAT('Change from ', OrgMatch, ' to ', ReMatchConfidence) AS Data,
Count(IF(Date="2017", 1, NULL)) as '2017',
Count(IF(Date="2016", 1, NULL)) as '2016'
FROM tables GROUP BY OrgMatch, ReMatchConfidence;
Try this:
SELECT CONCAT('Change from ', OrgMatch, ' to ', ReMatchConfidence) AS Data,
Count(IF(Date="2017", 1, NULL)) as '2017',
Count(IF(Date="2016", 1, NULL)) as '2016'
FROM tables GROUP BY OrgMatch, ReMatchConfidence;