new_gist_file

select 
  norm, 
	max(den), 
	score 
from 
	origin 
	inner join 
		(select 
			norm as a, 
			MAX(score) as m 
		from 
			origin 
		group BY 
			norm) as m 
		ON origin.norm = m.a and origin.score = m.m 
	group by 
		norm, score