Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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