How many bridges was built by Frank Lloyd Wright?
select count ( * ) from architect as t1 join bridge as t2 on t1.id = t2.architect_id where t1.name = "Frank lloyd Wright"
How many bridges was built by Frank Gehry?
select count ( * ) from architect as t1 join bridge as t2 on t1.id = t2.architect_id where t1.name = "Frank Gehry"
Who was the builder of Xian Ren Qiao (Fairy Bridge)?
select t1.name from architect as t1 join bridge as t2 on t1.id = t2.architect_id where t2.name = "Xian ren qiao ( fairy bridge ) "
What is the  name of id 2?
select name from architect where id = 2