Table: iso_3166_by_subdiv
Columns: code
subdivision_name_be_bgn_pcgn
subdivision_name_be_gost
subdivision_name_ru_bgn_pcgn
subdivision_name_ru_gost
subdivision_category

Question: What subdivision names (RU) have a code of by-hr?
SQL: SELECT "subdivision_name_ru_bgn_pcgn" FROM iso_3166_by_subdiv WHERE "code" = 'BY-HR'

Question: What cods have a subdivision name (RU) of Grodnenskaya Oblast'?
SQL: SELECT "code" FROM iso_3166_by_subdiv WHERE "subdivision_name_ru_bgn_pcgn" = 'Grodnenskaya oblast'''

Question: What are the subdivision names (RU) where the subdivision name (BE) is Hrodzenskaya Voblasts'?
SQL: SELECT "subdivision_name_ru_gost" FROM iso_3166_by_subdiv WHERE "subdivision_name_be_bgn_pcgn" = 'Hrodzenskaya voblasts'''

Question: What is the subdivision name (BE) where subdivision name (RU) (BGN) is Grodnenskaya Oblast'?
SQL: SELECT "subdivision_name_be_bgn_pcgn" FROM iso_3166_by_subdiv WHERE "subdivision_name_ru_bgn_pcgn" = 'Grodnenskaya oblast'''

Question: Which codes have subdivision names (BE) (BGN) of Homyel'skaya Voblasts'?
SQL: SELECT "code" FROM iso_3166_by_subdiv WHERE "subdivision_name_be_bgn_pcgn" = 'Homyel''skaya voblasts'''