Skip to content

Instantly share code, notes, and snippets.

@tal

tal/gist:340446

Created March 22, 2010 19:36
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save tal/340446 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save tal/340446 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
update fighters foo
set user_batting_average = (select (sum(`wins`) / sum(`views`))
from fighters bar
where foo.user_id = bar.user_id)
where foo.user_id in (select user_id from fighters)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment