Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

12,14,15 please. Athlete (aID NUMBER, aName VARCHAR2(20),Ranking NUMBER, age NUMBER) Event (eID CHAR(7), eName VARCHAR2 (20), eLocation VARCHAR2 (20)) Competes (aID NUMBER, eID CHAR(7), position

image text in transcribedimage text in transcribed

12,14,15 please.

Athlete (aID NUMBER, aName VARCHAR2(20),Ranking NUMBER, age NUMBER) Event (eID CHAR(7), eName VARCHAR2 (20), eLocation VARCHAR2 (20)) Competes (aID NUMBER, eID CHAR(7), position NUMBER, sport VARCHAR2(20), year NUMBER) Equipment (aID NUMBER, modelID NUMBER Model VARCHAR2 (20), Brand VARCHAR2 (20)) Event elD CHAR(5) eName VARCHAR2(20) alD NUMBER elD NUMBER Position NUMBER Sport VARCHAR2(20) Year NUMBER Athlete alD NUMBER aName VARCHAR2(20) Ranking NUMBER Age NUMBER Equipment alD NUMBER modellD NUMBER Model VARCHAR2(20) Brand VARCHAR2(20 Write the following Queries in SQL, run them, and the post the results (Question number 1 is done for you) 1. Find all athletes with a ranking of 1 SELECT A. aName FROM Athlete A WHERE A. Ranking 1; ANAME Luke Alex Kyle Jackson 2. Find the names and ages of all the athletes 3. Find the names of athletes who have competed in event '001Sk8P 4. Find all the event names Jackson competed in 5. Find the names of athletes who have competed in at least one event 6. Find the names of athletes who have competed in at least one event but did not compete at 'X Games 7. Find the names of athletes who have not competed at 'Dew Tour 8. Find the names of athletes who have competed at both 'X Games' and 'Dew Tour 9. Find the names of athletes who have competed at all 5 events 10. Find the average age and the youngest age of the athletes 11. Find the name of the oldest athlete 12. Find the names, sports, and positions of the athletes who competed in X Games 13. Find the name and sports of athletes whose name begins with the letter 'A 14. Find the model and brand of all the equipment used by Luke (AID 10) 15. Find the athlete ID and name of any athletes who competed in sports that include 'Moto' in the name of the sport

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Driven Web Sites

Authors: Mike Morrison, Joline Morrison

1st Edition

061901556X, 978-0619015565

More Books

Students also viewed these Databases questions

Question

Why is depreciation not recorded in governmental- type funds?

Answered: 1 week ago

Question

1. Let a, b R, a Answered: 1 week ago

Answered: 1 week ago