What institution does "Katsuhiro Ueno" belong to?
select distinct t3.name from authors as t1 join authorship as t2 on t1.authid = t2.authid join inst as t3 on t2.instid = t3.instid where t1.fname = "Katsuhiro" and t1.lname = "Ueno"
What is Katsuhiro Ueno's author ID?
select authid from authors where fname = 'Katsuhiro' and lname = 'Ueno'
Okay. What country is Tohoku University located in?
select country from inst where name = 'Tohoku University'
How many authors belong to Tohoku University?
select count ( * ) from inst as t1 join authorship as t2 on t1.instid = t2.instid where inst.name = 'Tohoku University'
What is Tohoku University's institution ID?
select instid from inst where name = 'Tohoku University'