Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ANY help would be appreciated !! Given the following schema based on a basketball team Player (ID: integer, Name: varchar(64), Birthday: date, Address: varchar(128), Email:
ANY help would be appreciated !!
Given the following schema based on a basketball team
Player (ID: integer, Name: varchar(64), Birthday: date, Address: varchar(128), Email: varchar(32), PhoneNumber: char(10), PlayPos: varchar(16))
Show the names and IDs of all players whose play position is center.
SELECT ID, name
FROM Player
WHERE PlayPos = Center;
Or
SELECT player.ID, player.name
FROM Player P
WHERE P.PlayPos = Center;
Am I close to the correct query ?
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