Table: general_councils_france
Columns: number
d_partment_or_collectivity
pr_sident
party
since

Question: Who is the president representing the Creuse department?
SQL: SELECT "pr_sident" FROM general_councils_france WHERE "d_partment_or_collectivity" = 'creuse'

Question: What number corresponds to Presidet Yves Krattinger of the Socialist party?
SQL: SELECT "number" FROM general_councils_france WHERE "party" = 'socialist party' AND "pr_sident" = 'yves krattinger'

Question: Which department has Guy-Dominique Kennel as president since 2008?
SQL: SELECT "d_partment_or_collectivity" FROM general_councils_france WHERE "since" = 2008 AND "pr_sident" = 'guy-dominique kennel'

Question: Who is the president from the Union for a Popular Movement party that represents the Hautes-Alpes department?
SQL: SELECT "pr_sident" FROM general_councils_france WHERE "party" = 'union for a popular movement' AND "d_partment_or_collectivity" = 'hautes-alpes'