All pastes #971340 Raw Edit

Someone

public sql v1 · immutable
·published 2008-04-04 17:44 UTC
rendered paste body
SELECT country.country_name, 	gross_national_product / sum( no_of_inhabitants ) AS gross_per_inhabitant, 	area / sum( no_of_inhabitants ) area_per_inhabitantFROM country, country_provinceWHERE country.country_name = country_province.country_nameGROUP BY country.country_nameSELECT country.country_name as coutry_name, 	area / sum( no_of_inhabitants ) area_per_inhabitant INTO coutry_crowdednessFROM country, country_province , EUCWHERE country.country_name = country_province.country_name	AND country.country_name != EUC.country_nameGROUP BY country.country_name     SELECT country_name, area_per_inhabitantFROM country_crowdednessWHERE area_per_inhabitant = ( SELECT max(area_per_inhabitant)	FROM country_crowdedness )