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 porcentagem LINKE obteve em Tyrol?
 ###Tabelas: CREATE TABLE highest-grossing_films_us_domestic (highest-grossing_films_us_domestic_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Title VARCHAR, Studio VARCHAR, Director VARCHAR, Gross VARCHAR) CREATE TABLE by_state (by_state_id AUTO_INCREMENT PRIMARY KEY, State VARCHAR, GRÜNE VARCHAR, FRITZ VARCHAR, RETTÖ VARCHAR, LINKE VARCHAR, STARK VARCHAR) CREATE TABLE mutya_ng_pilipinas_asia_pacific_titleholders_and_runners-up (mutya_ng_pilipinas_asia_pacific_titleholders_and_runners-up_id AUTO_INCREMENT PRIMARY KEY, Year INT, Mutya ng Pilipinas Asia Pacific VARCHAR, 1st runner-up VARCHAR, 2nd runner-up VARCHAR, 3rd runner-up VARCHAR, 4th runner-up VARCHAR) CREATE TABLE song_list (song_list_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Album name VARCHAR, Track VARCHAR, Track title VARCHAR, Lyricist VARCHAR, Music genre/style VARCHAR, Major instrument(s) VARCHAR, Lyrics theme/style VARCHAR, Duration VARCHAR) CREATE TABLE round_four (round_four_id AUTO_INCREMENT PRIMARY KEY, Pick # INT, CFL Team VARCHAR, Player VARCHAR, Position VARCHAR, College VARCHAR)  
SELECT LINKE FROM by_state WHERE State = tyrol