Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

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 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 S. 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

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

Students also viewed these Databases questions

Question

Write down a Simple Cash Budget

Answered: 1 week ago