What is the id of the routes whose source and destination airports are in the United States?
select rid from routes where dst_apid in (select apid from airports where country = 'United States') and src_apid in (select apid from airports where country = 'United States')