framework/resources/Functional/window_functions/multiple_partitions/q2.sql

-- multiple partitions : all have order by clause, partition by on a single (different) column

SELECT * 
FROM
	(
	SELECT 
		count(*) OVER (PARTITION BY c_date ORDER BY c_time) + sum(c_integer) OVER (PARTITION BY c_bigint ORDER BY c_time) AS total,
    		count(*) OVER (PARTITION BY c_integer ORDER BY c_time) AS count1,
    		sum(c_integer) OVER (PARTITION BY c_date ORDER BY c_time) AS count2
 	FROM j1
	) sub
;