-- Database schema
| College : cName [ TEXT ] primary_key , state [ TEXT ] , enr [ INT ] | Player : pID [ INT ] primary_key , pName [ TEXT ] , yCard [ TEXT ] , HS [ INT ] | Tryout : pID [ INT ] primary_key Tryout.pID = Player.pID , cName [ TEXT ] Tryout.cName = College.cName , pPos [ TEXT ] , decision [ TEXT ] |
-- -- What are the names of players whose training hours is between 500 and 1500?

SELECT pName FROM Player WHERE HS BETWEEN 500 AND 1500;