Create the queries listed below: (Just write the SQL command for each query)
1. RIDER - POINT TOTALS BY RACE LEVEL LISTING
o 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.
o Label as Q5a (easy race level), Q5b (intermediaterace level), Q5c (advancedrace level)
2. SEARCHING FOR A RUN
o 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
o 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. - Label as Q6
4. SUBQUERY
List the Sponsor Name of any sponsors who sponsored both Riders and Events.