text: explain plan for select * from (
  -- 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_v j1
  	) sub
  ) t limit 0;
  