Point totals by race level listing

Assignment Help PL-SQL Programming

Reference no: EM13725969

These are my tables. I just need a couple questions finished.

Teams (TeamID, TeamName) Agents (AgentID, FirstName, LastName, Street, City, State, Zip, Phone) Bikes (BikeID, BikeName, Description) Sponsors (SponsorID, SponsorName, Street, City, State, Zip, Phone) Riders (RiderID, FirstName, LastName, Street, City, State, Zip, Phone, DateJoined, AgentID, TeamID) Events (EventID, EventName, Description, Location, Street, City, State, Zip, StartDate, EndDate, SponsorID) Races (RaceID, RaceName, Description, RaceLevel, Location, RaceDate, StartTime, EndTime, EventID) Participation (PID, RiderID, RaceID, BikeID, Placement) Rider_Sponsorship (RSID, RiderID, SponsorID)

RIDER - POINT TOTALS BY RACE LEVEL LISTING

1. List the Rider's Name, RaceLevel as Race_Level and the total number of all points based on their placement. Make sure that you don't list any riders who have not raced in any races yet (not placed yet). Sort the data from highest to lowest total points. I need a listing for the easy races, one for the intermediate races and one for the advanced races. -

2. SEARCHING FOR A RUN List the EventName and the RaceName of any records that have the word "Run" in the Race Name.

3. RIDER - TEAM - AGENT BY RACE DATE LISTING List the Rider's Full Name AS "Rider_Name", The Rider's Team Name and their Agent's Full Name listed AS "Agent_Name" .Of those riders only list those who have or are schedule to participate in any races during April 2008 and, make sure that the riders information is only listed once. -

4. SUBQUERY List the Sponsor Name of any sponsors who sponsored both Riders and Events

Reference no: EM13725969

Questions Cloud

Project on branch offices : Your organization opened seven new branch offices in five states. Each branch office has five floors. All the branch offices use the same Internet domain name.

Explain the primary purpose of branding : The primary purpose of branding is: A producer might use a "pulling policy" rather than a "pushing policy" if

Training and the importance of the process : You are working in HR and have a group of new employees. You want to create information to facilitate the training and the importance of the process that goes into training.

Examine the elasticity of demand for you firms product : What is (are) your firm's primary competitive advantage(s)? In other words, what does your firm do well - are there entry barriers for firms in this industry - what substitutes are available for your product?

Point totals by race level listing : List the Rider's Name, RaceLevel as Race_Level and the total number of all points based on their placement. Make sure that you don't list any riders who have not raced in any races yet (not placed yet).

What insights have you had : What struck you in particular as you explored the course materials this week? What insights have you had? What have you been struggling with?

New manager training program on the various laws : The Key Assignment for this course will involve creating a PowerPoint presentation for a new manager training program on the various laws that are in the human resources (HR) management policy manual. The purpose of the presentation is to equip ne..

Differentiate between demand and quantity demanded : Differentiate between demand and quantity demanded. Differentiate between supply and quantity supplied. Give specific examples to illustrate what you are saying. 100-200 words each

Evaluate the impact of your meeting : Evaluate the impact of your meeting and the launching of your TQ plan, including two (2) strengths and two (2) weaknesses of the plan.

User Account

All Pages