gjask · November 8, 2016 21:30
diff --git a/pure_sql_pivot.sql b/pure_sql_pivot.sql
 select
  number_id,
  sum(case when gate = 1 then points end) gate1,
  sum(case when gate = 2 then points end) gate2,
  sum(points) points_total
 from check
 group by number_id;
	select
	number_id,
	sum(case when gate = 1 then points end) gate1,
	sum(case when gate = 2 then points end) gate2,
	sum(points) points_total
	from check
	group by number_id;