How many albums are there
select count ( * ) from albums
How many have fewer than ten tracks?
select count ( * ) from ( select count ( * ) from albums as t1 join tracks as t2 on t1.id = t2.album_id group by t1.id having count ( t1.id ) < 10 )
How many albums are there other than those?
select count ( * ) from ( select * from albums as t1 join tracks as t2 on t1.id = t2.album_id group by t1.id having count ( t1.id ) > = 10 )