Table: pref_caps_japan
Columns: capital
prefecture
region
island
pop

Question: Name the average pop for chūgoku and prefecture of okayama
SQL: SELECT AVG("pop") FROM pref_caps_japan WHERE "region" = 'chūgoku' AND "prefecture" = 'okayama'

Question: Name the highest pop for tottori
SQL: SELECT MAX("pop") FROM pref_caps_japan WHERE "prefecture" = 'tottori'

Question: Name the sum of pop for shizuoka
SQL: SELECT SUM("pop") FROM pref_caps_japan WHERE "prefecture" = 'shizuoka'

Question: Name the total number of pop for ibaraki
SQL: SELECT COUNT("pop") FROM pref_caps_japan WHERE "prefecture" = 'ibaraki'