Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

DSQL POSTGRES You got the following tables: 1. Players (ID, namie, gender, height) 2 Pk - Primary key Z FR-Foreign key 2. Scores (player ID,

image text in transcribed
image text in transcribed
DSQL POSTGRES You got the following tables: 1. Players (ID, namie, gender, height) 2 Pk - Primary key Z FR-Foreign key 2. Scores (player ID, competition.), sportsb, result) -Pk , and players is also a Fk that references to Players fable (ID), while sportid is also a FK that references to Sportstable (ID)- see table 3 below: 3. Sports (10, name, record) Note: name is UNIQUE. Based on these a given tables, write a single query (as simple as you possibly can) in order to retrieve the following info: - Select the ID and name of players that have no result is a sport called ex

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Readings In Database Systems

Authors: Michael Stonebraker

2nd Edition

0934613656, 9780934613651

More Books

Students also viewed these Databases questions