2

What is the proper syntax for a correlated subquery that connects all point guards earning over 2 million dollars with their respective teams?

edit

• point

asked 2023-05-14 14:54:34 +0000

lakamha
21 ●3 ●3

edit retag flag offensive close merge delete

add a comment

3

answered 2023-05-14 15:01:02 +0000

scrum
21 ●2 ●2

SELECT playername, teamname FROM players WHERE position = 'PG' AND salary > 2000000 AND teamname IN (SELECT teamname FROM players WHERE position = 'PG' AND salary > 2000000)

edit flag offensive delete link more

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss