The match that was held at Club Med Sandpiper has what method?
CREATE TABLE table_name_54 (method VARCHAR, venue VARCHAR)
SELECT method FROM table_name_54 WHERE venue = "club med sandpiper"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_54 (method VARCHAR, venue VARCHAR) Question: The match that was held at Club Med Sandpiper has what method? [/INST] SELECT method FROM table_name_54 WHERE venue = "club med sandpiper" </s>