Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write the following SQL Queries: Athlete aID NUMBER, aName VARCHAR2 (20), Ranking NUMBER, age NUMBER) Event (eID CHAR(7), eName VARCHAR2 (20), eLocation VARCHAR2 (20)) Competes
Write the following SQL Queries:
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 lD CHAR(S) eName VARCHAR2(20) elocation VARCHAR2(20) Competes D 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 Event Athlete AID ANAME RANKING AGE ELOCATION 002Moto Los Angeles Los Angeles Competes POSITICN SPORT Equipment AD MCDELID Fast Track 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 sportStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started