Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SQL POSTGRES you got the following tables: 1. Players (ID, name, gender, height) 2 PK-Primary key Z FR-Foreign key 2. Scores (player ID, competitions, sport
SQL POSTGRES you got the following tables: 1. Players (ID, name, gender, height) 2 PK-Primary key Z FR-Foreign key 2. Scores (player ID, competitions, sport b, result) -Pk , and players is also a Fk that references to Players fable (ID), while sportid is also a FK that references to sports table (ID) - see table 3 below: 3. Sports (10, name, record) Note: name is UNIQUE. - Select the ID and name of all players who have not set any recorols. Based on these 3 giren tables, write a single query (as simple as you possibly can) in order to retrieve the following info
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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