andrewscaya · November 4, 2016 19:48
diff --git a/over_order_by_lag.sql b/over_order_by_lag.sql
 SELECT
  event_id,
  date - lag(date) OVER (PARTITION BY event_id ORDER BY date) as difference
 FROM
  events;
diff --git a/over_partition_by.sql b/over_partition_by.sql
 SELECT
  dept,
  name,
  salary,
  AVG(salary) as avg_salary OVER (PARTITION BY dept)
 FROM
  employees;
	SELECT
	event_id,
	date - lag(date) OVER (PARTITION BY event_id ORDER BY date) as difference
	FROM
	events;
	SELECT
	dept,
	name,
	salary,
	AVG(salary) as avg_salary OVER (PARTITION BY dept)
	FROM
	employees;