yes.
select * from routes
Which of these is operated by American Airlines?
select * from airlines as t1 join routes as t2 on t1.alid = t2.alid where t1.name = 'American Airlines'
How many are they?
select count ( * ) from airlines as t1 join routes as t2 on t1.alid = t2.alid where t1.name = 'American Airlines'
What of those not operated by American Airlines?
select * from airlines as t1 join routes as t2 on t1.alid = t2.alid where t1.name ! = 'American Airlines'
How many routes are not operated by American Airlines?
select count ( * ) from airlines as t1 join routes as t2 on t1.alid = t2.alid where t1.name ! = 'American Airlines'