Question: 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. Based on these 3 giren tables, write a single query (as simple as you possibly can) in order to retrieve the following info: - Select the ID and name of all players who have not set any recorols
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
