Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A SQL You got the following tables: to competetitors ( 10, name, genderheight) Primary vey 2. Scores ( competitor ID, competition ID, sportid, result) as
A SQL You got the following tables: to competetitors ( 10, name, genderheight) Primary vey 2. Scores ( competitor ID, competition ID, sportid, result) as Primary key and competitor ID is also a foreign leey 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 (10, name, record) 3. Sports 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: that have - Select ID and name of competitors results in exactly 3 different sports
Step 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