使用agregate和条件查询而不加入（Bigquery标准sql）(Query with agregate and condition without join (Bigquery standard sql))

 我在表格中有这些数据 
 
column 1    column 2    condition   value
1   ABC 1   1
1   строка 2    0   1
1   строка 3    0   1
1   строка 4    0   1
1   строка 5    0   1
1   строка 6    0   1
2   BCD 1   1
2   строка 2    0   1
2   строка 3    0   1
 
 我不会有这个结果： 
 
column 1    column 2    sum of value
1   ABC 6
2   BCD 3
 
 此结果仅按第一列分组。 第二列显示条件为1的那些行上的值。在第三列中，我们得到列值的总和，不包括任何条件。 是否可以在没有连接的情况下执行此操作（因为表非常大） 

I have this data in table
 
column 1    column 2    condition   value
1   ABC 1   1
1   строка 2    0   1
1   строка 3    0   1
1   строка 4    0   1
1   строка 5    0   1
1   строка 6    0   1
2   BCD 1   1
2   строка 2    0   1
2   строка 3    0   1
 
And I wont to have this Result:
 
column 1    column 2    sum of value
1   ABC 6
2   BCD 3
 
This result is grouped by the first column only. The second column shows the values that are on those lines where the condition is 1. In the third column, we get the sum over the column value, not including any conditions. Is it possible to do this without join (because table very large)

原文：https://stackoverflow.com/questions/47471073