Table: public_figures_art
Columns: title_subject
public_office
artist
date_painted_created
medium

Question: What medium was used for the sculpture of George Harold Baker? 
SQL: SELECT "medium" FROM public_figures_art WHERE "title_subject" = 'George Harold Baker'

Question: Who was the subject of the sculpture created in 1982? 
SQL: SELECT "title_subject" FROM public_figures_art WHERE "date_painted_created" = '1982'

Question: Who was the subject of the bronze sculpture who was a colonist and soldier in Ville Marie, New France? 
SQL: SELECT "title_subject" FROM public_figures_art WHERE "medium" = 'Bronze' AND "public_office" = 'colonist and soldier in Ville Marie, New France'

Question: What was the public office of the subject whose sculpture was created in 1954? 
SQL: SELECT "public_office" FROM public_figures_art WHERE "date_painted_created" = '1954'

Question: What medium was used for the sculpture by Ernest Richard Gause? 
SQL: SELECT "medium" FROM public_figures_art WHERE "artist" = 'Ernest Richard Gause'