Find the id of 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')