SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

WITH your_table(title,record_datetime)
AS
(
SELECT 'fgame','2018-07-09 11:41:41' UNION ALL
SELECT 'fgame','2018-07-09 11:41:25' UNION ALL
SELECT 'fgame','2018-07-09 12:41:41' UNION ALL
SELECT 'source','2018-07-09 10:40:18' UNION ALL
SELECT 'source','2018-07-09 10:40:33' UNION ALL
SELECT 'source','2018-07-09 10:41:10' UNION ALL
SELECT 'setup','2018-07-24 09:49:11' UNION ALL
SELECT 'setup','2018-07-24 09:49:13'
)

SELECT title,
SUM(CASE WHEN DATEPART(HOUR,record_datetime) = 10 THEN 1 ELSE 0 END) AS '10.00',
SUM(CASE WHEN DATEPART(HOUR,record_datetime) = 11 THEN 1 ELSE 0 END) AS '11.00',
SUM(CASE WHEN DATEPART(HOUR,record_datetime) = 12 THEN 1 ELSE 0 END) AS '12.00',
SUM(1) total
FROM your_table
GROUP BY title

UNION ALL

SELECT 'sum', 
SUM(CASE WHEN DATEPART(HOUR,record_datetime) = 10 THEN 1 ELSE 0 END) AS '10.00',
SUM(CASE WHEN DATEPART(HOUR,record_datetime) = 11 THEN 1 ELSE 0 END) AS '11.00',
SUM(CASE WHEN DATEPART(HOUR,record_datetime) = 12 THEN 1 ELSE 0 END) AS '12.00',
SUM(1) total
FROM your_table

title	10.00	11.00	12.00	total
fgame	0	2	1	3
setup	0	0	0	2
source	3	0	0	3
sum	3	2	1	8