No CTEs are needed:

create table #temp (

TicketID int,

Name varchar(20),

Duration int

)

insert into #temp

values (10, 'Helen', 8),

(15, 'Blake', 12),

(20, 'Joe', 17),

(25, 'Joe', 16),

(30, 'Blake', 50),

(35, 'Helen', 20);

go

select

Name,

'Count' as Category,

count(Name) as Value

from

#temp

group by

Name

union all

select

Name,

'Duration' as Category,

sum(Duration) as Value

from

#temp

group by

Name

order by

Name;

go

drop table #temp;

go