SQL GROUP BY with a condition?

Question

I am trying to copy a table named "CLOUD" to a new one called "t1_temp" when grouping rows based on a column named "tag". BUT I want this to happen only if the Neighborhood column is identical.

Request in progress:

INSERT INTO t1_temp (id, NeighborhoodID, power, tag) SELECT id, NeighborhoodID, SUM(power), tag FROM CLOUD GROUP BY tag ORDER BY NeighborhoodID 

So for example:

The third entry should not be grouped with 1st and 4th cells, as the “NeighborhoodID” does not match.

I hope I understand, if not comment, thanks.

Answer 1

You can group by several columns, therefore:

 INSERT INTO t1_temp (id, NeighborhoodID, power, tag) SELECT id, NeighborhoodID, SUM(power), tag FROM CLOUD GROUP BY tag, NeighborhoodID ORDER BY NeighborhoodID 

Answer 2

I assume you want to add NeighborhoodID to the proposal group as well

  SELECT id, NeighborhoodID, SUM(power), tag FROM CLOUD GROUP BY tag, NeighborhoodID ORDER BY NeighborhoodID 

Answer 3

 INSERT INTO t1_temp (id, NeighborhoodID, power, tag) SELECT min(id), NeighborhoodID, SUM(power), tag FROM CLOUD GROUP BY NeighborhoodID, tag ORDER BY NeighborhoodID 

Does it help?