Question: A SQL You got the following tables: to competetitors ( 10, name, gender, height) Primary 2. Scores (competitor ID, competition 1D, sportiD, result) as Primary

 A SQL You got the following tables: to competetitors ( 10,
name, gender, height) Primary 2. Scores (competitor ID, competition 1D, sportiD, result)

A SQL You got the following tables: to competetitors ( 10, name, gender, height) Primary 2. Scores (competitor ID, competition 1D, sportiD, result) as Primary key and competitor ID is also a foreign key that references to competetitors table (ID) while sport ID is a foreign Icey that references to Sports table (ID) - see table 3 below: 3. Sports (16, name, record) Son 3. Note: name is UNIQUE. Primary key Based on those 3 given tables, write a single query (as simple as you possibly can) in order to retrieve the following information: - Select ID and name of competitors that have results in exactly 3 different sports

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!