Ket inner Join osszekapcsolase:

Sziasztok van ket inner joinon:

WITH g AS
(
SELECT date(z_timestamp), hour(z_timestamp), count(*) AS c FROM HUAWEI_3G.ZRAW_67109411 WHERE datetime > '2015-02-03' GROUP BY  date(z_timestamp), hour(z_timestamp)
SELECT g.date, g.hour, g.c, SUM(g2.c) as Newin 
  FROM g INNER JOIN g AS g2
  ON g.date >= g2.date AND g.hour >= g2.hour
GROUP BY g.date, g.hour, g.c
ORDER BY g.date, g.hour;

WITH z AS
(
SELECT date(datetime), hour(datetime), count(*) AS c FROM HUAWEI_3G.ZRAW_67109411 WHERE datetime > '2015-02-03' GROUP BY  date(datetime), hour(datetime) 
)
SELECT z.date, z.hour, z.c, SUM(z2.c) as Newin 
  FROM z INNER JOIN g AS z2
  ON z.date >= z2.date AND z.hour >= z2.hour
GROUP BY z.date, z.hour, z.c
ORDER BY z.date, z.hour;

Mint lathato ugyanazzal a tablaval dolgozik mindketto. Valami ilyen kimenet kellene:
SELECT g.date, g.hour, SUM(g2.c)-SUM(z2.c)