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’
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