sql - 划分两个查询的输出

Question

我想编写一个查询，输出 a/c(a 除以 c)按名为 cobrand_id 的变量分组。

编写此查询的最无缝方式是什么？谢谢。

    select sum(calc) a, cobrand_id b 
from temp_08.jwn_calc 
where optimized_transaction_date > '2015-10-31' 
and optimized_transaction_date <= '2015-10-31' + 45 
GROUP BY cobrand_id

    select sum(calc) c, cobrand_id d 
from temp_08.jwn_calc 
where optimized_transaction_date > '2015-10-31' 
and optimized_transaction_date <= '2015-10-31' + 91 
GROUP BY cobrand_id

Answer 1

您可以将现有查询用作子查询并将它们连接起来以划分 a/c

Select q1.b, q1.a/q2.c as result
From (your first query) q1
Inner join (your second query) q2 on q1.b = q2.d