Table: kotonishiki
Columns: name
total
first
last
highest_rank

Question: Who had a total of 34?
SQL: SELECT "name" FROM kotonishiki WHERE "total" = 34

Question: What rank is Takatōriki having less than 30 total?
SQL: SELECT "highest_rank" FROM kotonishiki WHERE "total" < 30 AND "name" = 'takatōriki'

Question: What was the total when the first was November 1966?
SQL: SELECT SUM("total") FROM kotonishiki WHERE "first" = 'november 1966'

Question: What is the last when the first was January 2001 and more than 26 total?
SQL: SELECT "last" FROM kotonishiki WHERE "total" > 26 AND "first" = 'january 2001'

Question: What is the greatest total when the last was September 1970?
SQL: SELECT MAX("total") FROM kotonishiki WHERE "last" = 'september 1970'

Question: What rank is Takatōriki?
SQL: SELECT "highest_rank" FROM kotonishiki WHERE "name" = 'takatōriki'