Query: List the capital cities and populations of countries whose GDP exceeds one trillion dollars

SELECT Co.Name,Co.Pop
FROM CITY Ci, COUNTRY Co
WHERE Ci.Country=Co.Name
AND Co.GDP > 1000.0
AND Ci.Capital = ‘Y’

Ci.Name
Co.Pop
Brasilia
183.3
Washington, D.C.
270.0

Query: What is the name and population of the capital city in the country where the St. Lawrence River originates?

SELECT Ci.Name,Ci.Pop
FROM CITY Ci, COUNTRY Co, RIVER R
WHERE R.Origin=Co.Name
AND Co.Name = Ci.Country
AND R.Name =‘St. Lawrence’
AND Ci.Capital = ‘Y’

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