Skip to content

Instantly share code, notes, and snippets.

@tathagata

tathagata/count-join.sql

Created June 28, 2013 15:26
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save tathagata/5885533 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
count-join.sql
select count(*)/3573.0*100.0from HospitalsOnTwitter h, survey_names s where h.organization=s.name;
8.22837951301427
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment