我有一个名为DETAILS的表，它具有5个数字列DETAILS（id，key2，key3，num1，num2，num3，num4，num5）。id，key2和key3的组合是主键。每个ID可能有多行。

我的要求是获取按ID分组的每列的前10个SUM值，如下所示。

select   id
        ,sum(num1) val1
 from details   
group by id
order by sum(num1) desc nulls last
limit 10;

select   id
        ,sum(num2) val2
 from details  
group by id
order by sum(num2) desc nulls last
limit 10;

select   id
        ,sum(num3) val3
 from details   
group by id
order by sum(num3) desc nulls last
limit 10;

select   id
        ,sum(num4) val4
 from details   
group by id
order by sum(num4) desc nulls last
limit 10;

select   id
        ,sum(num5) val5
 from details
group by id
order by sum(num5) desc nulls last
limit 10;

我需要根据以下ID合并以上结果

id, sum(num1), sum(num2), sum(num3), sum(num4), sum(num5)

假设第一个查询返回

[{id: 1, val1: 50}, {id: 2, val1: 60}, {id: 3, val1: 70}]

第二个查询返回

[{id: 3, val2: 150}, {id: 4, val2: 160}, {id: 3, val2: 170}]

结果应该是

[
{id: 1, val1: 50, val2: null}, 
{id: 2, val1: 60, val2: null}, 
{id: 3, val1: 70, val2: 150},
{id: 4, val1: null, val2: 160},
{id: 5, val1: null, val2: 170},
]

使用join或其他查询进行单一查询是否可行？如果是这样，如何通过优化查询来实现？