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: Onde fica a ponte Kap Shui Mun?
 ###Tabelas: CREATE TABLE completed_cable-stayed_bridges (completed_cable-stayed_bridges_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Location VARCHAR, Country VARCHAR, Longest span VARCHAR, Comp INT, Pylons VARCHAR) CREATE TABLE biggest_attendances (biggest_attendances_id AUTO_INCREMENT PRIMARY KEY, Competition VARCHAR, Attendance INT, Opponent VARCHAR, Season VARCHAR, Result VARCHAR) CREATE TABLE opinion_polling (opinion_polling_id AUTO_INCREMENT PRIMARY KEY, Date Released VARCHAR, Polling institute VARCHAR, Socialist VARCHAR, Social Democratic VARCHAR, Green-Communist VARCHAR, People's Party VARCHAR, Left Bloc VARCHAR, Lead VARCHAR) CREATE TABLE supply-demand_gap (supply-demand_gap_id AUTO_INCREMENT PRIMARY KEY, Country VARCHAR, Uranium required 2006-08 VARCHAR, % of world demand VARCHAR, Indigenous mining production 2006 VARCHAR, Deficit (-surplus) VARCHAR) CREATE TABLE most_goals_in_a_game (most_goals_in_a_game_id AUTO_INCREMENT PRIMARY KEY, Rank VARCHAR, Score VARCHAR, Player VARCHAR, Club VARCHAR, Opponent VARCHAR, Year VARCHAR, Round VARCHAR, Venue VARCHAR)  
SELECT Location FROM completed_cable-stayed_bridges WHERE Name = kap shui mun bridge