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: question: Nomeie o georgios samaras da liga escocesa premier
 ###Tabelas: CREATE TABLE top_scorers (top_scorers_id AUTO_INCREMENT PRIMARY KEY, R INT, Player VARCHAR, Scottish Premier League INT, Scottish Cup INT, Scottish League Cup INT, Champions League (qualifying) INT, Europa League INT, Total INT) CREATE TABLE college_statistics (college_statistics_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Team VARCHAR, Attempts VARCHAR, Completions VARCHAR, Completion % VARCHAR, Yards VARCHAR) CREATE TABLE indoor (indoor_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Division VARCHAR, League VARCHAR, Regular Season VARCHAR, Playoffs VARCHAR) CREATE TABLE singles_champions (singles_champions_id AUTO_INCREMENT PRIMARY KEY, Location VARCHAR, Year INT, Champion VARCHAR, Runner-up VARCHAR, Score VARCHAR) CREATE TABLE seasonal_ratings_broadcast_history (seasonal_ratings_broadcast_history_id AUTO_INCREMENT PRIMARY KEY, Season INT, Network VARCHAR, Time slot VARCHAR, Season premiere VARCHAR, Season finale VARCHAR, Episode count INT, TV season VARCHAR, Season rank VARCHAR, Viewers (in millions) INT)  
SELECT Scottish Premier League FROM top_scorers WHERE Player = Georgios Samaras