Select COUNT(*)
FROM Transactions
INNER JOIN (SELECT * FROM Time_D WHERE Time_D.hour < 12) AS morn
ON Transactions.time_key=morn.time_key AND Transactions.trans_type='wd'
GROUP BY Transactions.client_id, Transactions.source_branch

Select COUNT(*)
FROM Transactions
INNER JOIN (SELECT * FROM Time_D WHERE Time_D.hour < 12) AS morn
ON Transactions.time_key=morn.time_key AND Transactions.trans_type='dep'
GROUP BY Transactions.client_id, Transactions.source_branch

Select COUNT(*)
FROM Transactions
INNER JOIN (SELECT * FROM Time_D WHERE Time_D.hour < 12) AS morn
ON Transactions.time_key=morn.time_key
GROUP BY Transactions.client_id, Transactions.source_branch