Как сделать "повёрнутую таблицу" с колонками значений?

SELECT * FROM crosstab(
$$with src(R,T,C) AS (VALUES 
(1, 'a', 10), (1, 'b', 15), (1, 'c', 8), (1, 'd', 4),
(2, 'a', 3), (2, 'b', 5), (2, 'c', 6), (2, 'd', 10),
(3, 'a', 13), (3, 'b', 25), (3, 'c', 36), (3, 'd', 11)
) SELECT * FROM src$$,
$$values ('a'),('b'),('c'),('d')$$
) AS (R INT, a INT, b INT, c INT, d INT);

WITH src(R,T,C) AS (VALUES 
(1, 'a', 10), (1, 'b', 15), (1, 'c', 8), (1, 'd', 4),
(2, 'a', 3), (2, 'b', 5), (2, 'c', 6), (2, 'd', 10),
(3, 'a', 13), (3, 'b', 25), (3, 'c', 36), (3, 'd', 11)
) 
SELECT 
theR.R r, 
(SELECT C FROM src AS theC WHERE theC.R = theR.R AND theC.T = 'a') a,
(SELECT C FROM src AS theC WHERE theC.R = theR.R AND theC.T = 'b') b,
(SELECT C FROM src AS theC WHERE theC.R = theR.R AND theC.T = 'c') c,
(SELECT C FROM src AS theC WHERE theC.R = theR.R AND theC.T = 'd') d
FROM (SELECT DISTINCT R FROM src) AS theR;

WITH src(R,T,C) AS (VALUES 
    (1, 'a', 10), (1, 'b', 15), (1, 'c', 8), (1, 'd', 4),
    (2, 'a', 3), (2, 'b', 5), (2, 'c', 6), (2, 'd', 10),
    (3, 'a', 13), (3, 'b', 25), (3, 'c', 36), (3, 'd', 11)
) 
SELECT 
    R,
    SUM(C) FILTER (WHERE T = 'a') a, SUM(C) FILTER (WHERE T = 'b') b,
    SUM(C) FILTER (WHERE T = 'c') c, SUM(C) FILTER (WHERE T = 'd') d
FROM src GROUP BY R