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 papel John Wayne desempenhou em The Trail Beyond, dirigido por R.N. Bradbury?
 ###Tabelas: CREATE TABLE historical (historical_id AUTO_INCREMENT PRIMARY KEY, Begin Date VARCHAR, Representative VARCHAR, Date of birth VARCHAR, House term VARCHAR, State served VARCHAR, Party VARCHAR, Age (years, days) VARCHAR) CREATE TABLE girls'_basketball_players_and_coaches_of_the_year (girls'_basketball_players_and_coaches_of_the_year_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Player VARCHAR, School VARCHAR, Hometown VARCHAR, College VARCHAR) CREATE TABLE 1934 (1934_id AUTO_INCREMENT PRIMARY KEY, Title VARCHAR, Studio VARCHAR, Role VARCHAR, Leading lady VARCHAR, Director VARCHAR) CREATE TABLE regular_season_schedule (regular_season_schedule_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Home Team VARCHAR, Score VARCHAR, Visiting Team VARCHAR, Stadium VARCHAR) CREATE TABLE competitive_history (competitive_history_id AUTO_INCREMENT PRIMARY KEY, Year INT, Competition VARCHAR, Location VARCHAR, Apparatus VARCHAR, Rank-Final INT, Score-Final VARCHAR, Rank-Qualifying INT, Score-Qualifying VARCHAR)  
SELECT Role FROM 1934 WHERE Director = r.n. bradbury AND Title = the trail beyond