How long is the Fairy Bridge?
select length_meters from bridge where name = "Fairy Bridge"
Can you find the bridge name Xian Ren Qiao?
select * from bridge where name = "Xian ren qiao ( fairy bridge ) "
Do you know who the architect is for that bridge?
select * from bridge as t1 join architect as t2 on t1.architect_id = t2.id where t1.name = 'Xian ren qiao ( fairy bridge ) '
What other bridges did Wright architect?
select * from bridge as t1 join architect as t2 on t1.architect_id = t2.id where t2.name = "Frank lloyd Wright" and t1.name ! = "Xian ren qiao ( fairy bridge ) "
Do you know the mills built by architects who also built a bridge longer than 80 meters?
select * from mill as t1 join architect as t2 on t1.architect_id = t2.id join bridge as t3 on t3.architect_id = t2.id where t3.length_meters > 80