rex-lin · August 13, 2018 17:23
diff --git a/Featured Creators b/Featured Creators
 select created_by as user_id, b.username as username, b.name as name, count(1) as feature_count, max(a.date_created) as last_feature
 from pf.dim_flipagram a
 join pf.dim_user b on a.created_by = b.id
 where a.date_created >= '2017-01-01'
 and featured = 'True'
 group by 1,2,3
 order by 4 desc
 limit 1000
	select created_by as user_id, b.username as username, b.name as name, count(1) as feature_count, max(a.date_created) as last_feature
	from pf.dim_flipagram a
	join pf.dim_user b on a.created_by = b.id
	where a.date_created >= '2017-01-01'
	and featured = 'True'
	group by 1,2,3
	order by 4 desc
	limit 1000
No results found