SDB101 » Select: Query 8
 
Query: List the GDP and the distance of a country’s capital city to the equator for all countries

SELECT Co.GDP, Distance(Point(0,Ci.Shape.y),Ci.Shape) AS “Distance”
FROM COUNTRY Co,CITY Ci
WHERE Co.Name = Ci.Country
AND Ci.Capital=‘Y’

Co. Name
Co. GDP
Dist-to-Eq (in Km)
Havana
16.9
2562
Washington, D.C.
8003
4324
Brasilia
1004
1756
Ottawa
658
5005
Mexico City
694.3
2161
Buenos Aires
348.2
3854

Última modificación: Thursday, 17 de November de 2005, 17:39