CREATE TABLE table_name_37 (opponents_in_the_final VARCHAR2, date VARCHAR2, partnering VARCHAR2, surface VARCHAR2)

Who did Bruno Soares and a partner face in the finals on a clay surface on August 1, 2010?
SELECT opponents_in_the_final FROM table_name_37 WHERE partnering = "bruno soares" AND surface = "clay" AND date = "august 1, 2010"
SELECT "opponents_in_the_final" FROM "table_name_37" WHERE "august 1, 2010" = "date" AND "bruno soares" = "partnering" AND "clay" = "surface"