Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Qual é o método do oponente Georges St-Pierre?
 ###Tabelas: CREATE TABLE overview (overview_id AUTO_INCREMENT PRIMARY KEY, Editor VARCHAR, Site VARCHAR, Style, clone of VARCHAR, Cost ( US$ ) VARCHAR, Open source VARCHAR, Activity VARCHAR) CREATE TABLE u.s._metropolitan_areas_with_large_indian_american_populations (u.s._metropolitan_areas_with_large_indian_american_populations_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Metropolitan Statistical Area VARCHAR, Total Population (2010) INT, Indian American Population (2010) INT, % Indian American VARCHAR, Asian American Population (2010) INT, % Asian American VARCHAR, Combined Statistical Area VARCHAR) CREATE TABLE united_kingdom_channel_4 (united_kingdom_channel_4_id AUTO_INCREMENT PRIMARY KEY, Episode number INT, Title VARCHAR, Original airing on Channel 4 VARCHAR, Time of airing on Channel 4 VARCHAR, Original airing on E4 VARCHAR, Time of airing on E4 VARCHAR, Position in Channel 4s ratings a VARCHAR, Position in E4s ratings b VARCHAR, Total viewers VARCHAR) CREATE TABLE _1482–1700 (_1482–1700_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Father VARCHAR, Birth VARCHAR, Marriage VARCHAR, Became Countess VARCHAR, Ceased to be Countess VARCHAR, Death VARCHAR, Spouse VARCHAR) CREATE TABLE mixed_martial_arts_record (mixed_martial_arts_record_id AUTO_INCREMENT PRIMARY KEY, Res. VARCHAR, Record VARCHAR, Opponent VARCHAR, Method VARCHAR, Event VARCHAR, Round INT, Time VARCHAR, Location VARCHAR)  
SELECT Method FROM mixed_martial_arts_record WHERE Opponent = georges st-pierre