Table: us_ambassador_bolivia
Columns: representative
title
presentation_of_credentials
termination_of_mission
appointed_by

Question: What is the termination of mission date of the representative with a presentation of credentials date on July 4, 1898?
SQL: SELECT "termination_of_mission" FROM us_ambassador_bolivia WHERE "presentation_of_credentials" = 'july 4, 1898'

Question: What is the presentation of credentials date of raúl h. castro, who has a title of ambassador extraordinary and plenipotentiary?
SQL: SELECT "presentation_of_credentials" FROM us_ambassador_bolivia WHERE "title" = 'ambassador extraordinary and plenipotentiary' AND "representative" = 'raúl h. castro'

Question: Who is the representative with a presentation of credentials date on February 23, 1854?
SQL: SELECT "representative" FROM us_ambassador_bolivia WHERE "presentation_of_credentials" = 'february 23, 1854'

Question: What is the title of the representative appointed by James K. Polk?
SQL: SELECT "title" FROM us_ambassador_bolivia WHERE "appointed_by" = 'james k. polk'

Question: What is the termination of mission date of the representative appointed by Franklin Pierce with a title of chargé d'affaires?
SQL: SELECT "termination_of_mission" FROM us_ambassador_bolivia WHERE "appointed_by" = 'franklin pierce' AND "title" = 'chargé d''affaires'