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: August 31, 2009 10:51am EDT | |
| TITLE | Return all field goals for a game and their yardage |
|---|---|
| SPORTS | American Football |
| QUERY | SELECT display_names.first_name, display_names.last_name, american_football_action_participants.participant_role, american_football_action_participants.yards_gained, american_football_action_plays.comment, american_football_event_states.period_value, american_football_event_states.period_time_remaining from american_football_event_states, american_football_action_plays, american_football_action_participants, events, display_names where events.event_key = 'l.nfl.com-2008-e.2687' AND american_football_event_states.context = 'event' AND american_football_event_states.event_id = events.id AND american_football_action_plays.american_football_event_state_id = american_football_event_states.id AND american_football_action_participants.american_football_action_play_id = american_football_action_plays.id AND american_football_action_participants.person_id = display_names.entity_id AND display_names.entity_type = 'persons' AND american_football_action_plays.score_attempt_type = 'field-goal' ORDER BY american_football_event_states.sequence_number asc; |
| DESCRIPTION | If you need to know the yardage for each successful FG attempt, not just the total number for each kicker, you have to query the action tables that stores each play. The yardage column holds the length of the attempt. |
| DBs TESTED | MySQL |
| ADDITIONAL NOTES | |