SportsDB Home
Documentation
Specification
Samples
Query Library
SportsCaster Web Service
Hosted on SourceForge
and licensed under
Creative Commons GNU GPL.
Query Library
| Casey Trauer submitted this query on: June 11, 2009 4:50pm EDT | |
| TITLE | BCS poll query |
|---|---|
| SPORTS | American Football |
| QUERY | SELECT dn.first_name, dn.last_name, rankings.issuer, rankings.ranking_value FROM rankings JOIN sub_seasons ss ON rankings.date_coverage_id = ss.id JOIN teams t ON rankings.participant_id = t.id JOIN display_names dn ON t.id = dn.entity_id JOIN document_fixtures df ON rankings.document_fixture_id = df.id WHERE ss.sub_season_key = '2008_season_regular' AND df.fixture_key = 'ranking-bcs' AND dn.entity_type = 'teams'; |
| DESCRIPTION | This query returns all values sent in the BCS poll: Harris rank, USA Today rank, previous rank, computer rating, and BCS rating. Each value gets a separate row, so five rows for each team. You can tweak the query to return only the BCS rating. |
| DBs TESTED | MySQL |
| ADDITIONAL NOTES | |