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 taxa de transferência o Birmingham City recebeu em 30 de junho de 2010?
 ###Tabelas: CREATE TABLE list_of_protected_forests (list_of_protected_forests_id AUTO_INCREMENT PRIMARY KEY, Central Forest Reserve VARCHAR, Size in km² INT, Total plant species INT, Tree species INT, Endemic INT, Threatened (CR,VU,EN) INT) CREATE TABLE in (in_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Country VARCHAR, Type VARCHAR, Moving from VARCHAR, Transfer window VARCHAR, Ends VARCHAR, Transfer fee VARCHAR) CREATE TABLE winners_and_honorees (winners_and_honorees_id AUTO_INCREMENT PRIMARY KEY, Year INT, Player VARCHAR, Country VARCHAR, Score VARCHAR, Margin of victory VARCHAR, Winner's share ( $ ) INT) CREATE TABLE main_round (main_round_id AUTO_INCREMENT PRIMARY KEY, Position INT, Name VARCHAR, Played INT, Drawn INT, Lost INT, Points INT) CREATE TABLE council_composition (council_composition_id AUTO_INCREMENT PRIMARY KEY, Party VARCHAR, Previous council INT, Staying councillors INT, Seats up for election INT, Election result INT, New council INT)  
SELECT Transfer fee FROM in WHERE Ends = 30 june 2010 AND Moving from = birmingham city