Table: capital_punishment_france
Columns: executed_person
date_of_execution
place_of_execution
crime
method
under_president

Question: under which president was gunther volz executed?
SQL: SELECT "under_president" FROM capital_punishment_france WHERE "executed_person" = 'Gunther Volz'

Question: who was executed during president charles de gaulle's reign for thr crime of child murder after rape?
SQL: SELECT "executed_person" FROM capital_punishment_france WHERE "under_president" = 'Charles de Gaulle' AND "crime" = 'Child murder after rape'

Question: where was mazouz ghaouti executed?
SQL: SELECT "place_of_execution" FROM capital_punishment_france WHERE "executed_person" = 'Mazouz Ghaouti'

Question: for what crime was gunther volz executed at metz?
SQL: SELECT "crime" FROM capital_punishment_france WHERE "place_of_execution" = 'Metz' AND "executed_person" = 'Gunther Volz'