Skip to content

Instantly share code, notes, and snippets.

@burin
Created November 19, 2008 23:42
Show Gist options
  • Save burin/26826 to your computer and use it in GitHub Desktop.
Save burin/26826 to your computer and use it in GitHub Desktop.
select p.screen_name, avg(a.best_answer)*100 as best_answer_percentage from answers a, profiles p where a.profile_id = p.id group by p.screen_name order by best_answer_percentage desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment