SELECT LOCATION ,  name FROM stadium WHERE capacity BETWEEN 5000 AND 10000
Show location and name for all stadiums with a capacity between 5000 and 10000.
SELECT LOCATION , name FROM stadium WHERE capacity BETWEEN 5000 AND 10000
select location , name from stadium where capacity between value and value
Show location and name for all stadiums with a capacity between 5000 and 10000 .