Merge output of two Queries MYSQL
This is a common trick of counting conditionally into several columns, depending on a condition using the IF() expression:

mysql&gt; SELECT DATE_FORMAT(date,'%m-%d %H:00') AS Date,  
              SUM(IF(type = 'client', 1, 0)) AS `Client Count`,
              SUM(IF(type = 'staff', 1, 0)) AS `Staff Count`,
FROM ticket_data  
WHERE department = 'support' 
GROUP BY DAY(`Date`), HOUR(`Date`) 
ORDER BY `Date` ASC 
LIMIT 10;