Race%20table%20relationships%20model%20and%20queries

Race%20table%20relationships%20model%20and%20queries - 1....

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Runner Database queries: 1. List the names and phone numbers of all runners (Uses SELECT, FROM) 2. List the race id, race name and city of all of the races held in Kansas (KS) 3. List the names and phone numbers of all runners in club order 4. List the names and times of all runners for the St. Nicholas Run in time order. 5. List the names and times of all runners for all 5K races. 6. List by last name the times and related race names for all runners in the Run Out club. 7. List in club order the names, race names and times of all members of a club in Denver who ran in a race in Kansas City. Runner Database queries:
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1. List the names and phone numbers of all runners (Uses SELECT, FROM) 2. List the race id, race name and city of all of the races held in Kansas (KS) 3. List the names and phone numbers of all runners in club order 4. List the names and times of all runners for the St. Nicholas Run in time order. 5. List the names and times of all runners for all 5K races. 6. List by last name the times and related race names for all runners in the Run Out club. 7. List in club order the names, race names and times of all members of a club in Denver who ran in a race in Kansas City....
View Full Document

This note was uploaded on 08/07/2011 for the course ACC 380 taught by Professor Harkness during the Spring '11 term at University of Michigan-Dearborn.

Ask a homework question - tutors are online