human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: No, City district (Stadtteil), Area in km², Population, Foreign nationals, Foreign nationals in %, Area district (Ortsbezirk)
###Question: What is the city where the number is 47?
gpt
SELECT City district (Stadtteil) FROM table WHERE No = 47