已关闭此贴

SELECT
    MAX( uid ) uid,
    MAX( pid ) pid,
    SUM( score ) score,
    SUM( CASE WHEN type = 1 THEN score ELSE 0 END ) type1,
    SUM( CASE WHEN type = 2 THEN score ELSE 0 END ) type2,
    SUM( CASE WHEN type = 3 THEN score ELSE 0 END ) type3,
    MAX( created_at ) created_at 
FROM
    table 
GROUP BY
    uidCopy

SELECT
    pid,
    uid,
    SUM( score ) AS score,
    MAX( created_at ) AS created_at,
    SUM( CASE WHEN type = 1 THEN score ELSE 0 END ) AS type1,
    SUM( CASE WHEN type = 2 THEN score ELSE 0 END ) AS type2,
    SUM( CASE WHEN type = 3 THEN score ELSE 0 END ) AS type3,
    SUM( CASE WHEN type = 4 THEN score ELSE 0 END ) AS type4
FROM
    demo_x
GROUP BY
    uidCopy