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 nome da empresa de motores localizada na 89 Rope Ferry Road?
 ###Tabelas: CREATE TABLE list_of_recent_lower_tier_county_cup_south_winners (list_of_recent_lower_tier_county_cup_south_winners_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Junior (South) Winners VARCHAR, Intermediate (South) Winners VARCHAR, Minor (South) Winners VARCHAR, Primary (South) Winners VARCHAR) CREATE TABLE fire_station_locations_and_apparatus (fire_station_locations_and_apparatus_id AUTO_INCREMENT PRIMARY KEY, Station VARCHAR, Engine Company VARCHAR, Ambulance VARCHAR, Address VARCHAR, Phone VARCHAR) CREATE TABLE doubles_champion_6 (doubles_champion_6_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents in the final VARCHAR, Score in the final VARCHAR) CREATE TABLE awards_and_nominations (awards_and_nominations_id AUTO_INCREMENT PRIMARY KEY, Year INT, Award VARCHAR, Work VARCHAR, Cole VARCHAR, Dylan VARCHAR) CREATE TABLE teams_and_standings (teams_and_standings_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Players VARCHAR, Placing INT, Round Robin W-L VARCHAR, Matches W-L VARCHAR, Sets W-L VARCHAR)  
SELECT Engine Company FROM fire_station_locations_and_apparatus WHERE Address = 89 rope ferry road