postgis-workshop/simple_sql_exercises — Chinese (Simplified) @ OSGeo Weblate: Name of the New York borough. Manhattan, The Bronx, Brooklyn, …

Translation

English

Chinese (Simplified)

Needs editing

Skip

	English	Chinese (Simplified)	Actions
	popn_black	popn_black
	Number of people self-identifying as "black" in the block	该街区中自称为“黑人”的人数
	popn_nativ	popn_nativ
	Number of people self-identifying as "native american" in the block	街区中自认为“美洲原住民”的人数
	popn_asian	popn_asian
	Number of people self-identifying as "asias" in the block	该街区中自称“亚洲人”的人数
	popn_other	popn_other
	Number of people self-identifying with other categories in the block	在该区域自我认同为其他类别的人数
	hous_total	hous_total
	Number of housing units in the block	在这个街区中的住房单位数量
	hous_own	hous_own
	Number of owner-occupied housing units in the block	该街区中的自住住房单位数量
	hous_rent	hous_rent
	Number of renter-occupied housing units in the block	该街区中的租赁住房单位数量
	boroname	boroname
	Name of the New York borough. Manhattan, The Bronx, Brooklyn, Staten Island, Queens	纽约市的行政区名称分别是：曼哈顿、布朗克斯、布鲁克林、史泰登岛和皇后区。
	geom	geom
	Polygon boundary of the block	街区的多边形边界
	And, here are some common SQL aggregation functions you might find useful:	以下是一些常见的SQL聚合函数，您可能会发现它们很有用：
	avg() - the average (mean) of the values in a set of records	avg() - 一组记录中值的平均值（均值）
	sum() - the sum of the values in a set of records	sum() - 一组记录中值的总和
	count() - the number of records in a set of records	count() - 一组记录中的记录数量
	Now the questions:	现在的问题是：
	How many records are in the nyc_streets table?	nyc_streets表中有多少条记录？
	How many streets in NYC start with ‘B’?	纽约市有多少条街道以'B'开头？
	What is the population of the City of New York?	纽约市的人口是多少？
	What is this ``AS``? You can give a table or a column another name by using an alias. Aliases can make queries easier to both write and to read. So instead of our outputted column name as ``sum`` we write it AS the more readable ``population``.	这个``AS``是什么？通过使用别名，您可以给表或列指定另一个名称。别名可以使查询更容易编写和阅读。因此，我们将输出的列名``sum``写成更可读的别名``population``。
	What is the population of the Bronx?	Bronx的人口是多少？
	How many "neighborhoods" are in each borough?	每个行政区有多少个“社区”？
	For each borough, what percentage of the population is white?	每个行政区的白人人口占总人口的百分比是多少？
	Function List	函数列表