擅长:python、mysql、java
<blockquote>
<p>I want to create a table that contains the "NOM_ENSEMBLE" and "DATE" with the sum of impressions, clicks, spend for the same DATE/NOM_ENSEBMLE!</p>
</blockquote>
<p>如果要进行聚合,则需要一个<code>GROUP BY</code>。<code>GROUP BY</code>应该只包含<code>SELECT</code>中未聚合的列。因此,查询应该如下所示:</p>
<pre><code>SELECT date, NOM_ENSEMBLE,
SUM(impressions) AS IMPRESSIONS,
SUM(clicks) AS CLICKS,
SUM(spend) AS SPEND
FROM `my-project.dugut.for_analysis`
GROUP BY date, NOM_ENSEMBLE;
</code></pre>