Hier schon mal unsere Ergebnisse bis hierher. Hat jemand was zur 6? Wie kann man die Meeroberfläche berechnen?
select organization.name, sum(Country.Population) as sum from IS_MEMBer, country , organization where IS_Member.country = Country.code and organization.abbreviation = IS_Member.organization group by organization.name order by sum Desc
select ENCOMPASSES.country, country.Name, mou.hei, mou.cou, mou.nam from ENCOMPASSES , country, ( select max(mo.height) as hei, m2.country as cou, ( select mountain.name from mountain where mountain.height = max(mo.height)) as nam from mountain as mo, geo_mountain as m2 where m2.mountain=mo.name group by m2.country) as mou where ENCOMPASSES.continent = 'Asia' and ENCOMPASSES.country = mou.cou and ENCOMPASSES.country=country.code
select a.name, sum(a.population) from (select country.name, /*borders.country1 as nachbar,*/ (select country.population as zahl from country where country.code = borders.country1) as population from country, borders where country.code = borders.country2 union select country.name, /*borders.country2 as nachbar, */ (select country.population as zahl from country where country.code = borders.country2) as population from country, borders where country.code = borders.country1 ) A group by a.name
select cou.n as name from (select two.na as n, count(two.cont) as za from (select organization.name as na, encompasses.continent as cont from organization, IS_MEMBER, Encompasses where organization.Abbreviation=IS_MEMBER.Organization and is_member.country=encompasses.country group by organization.name , encompasses.continent) two group by two.na) cou where cou.za = (select count(continent.name) from continent)
select country.name, sum(city.population) / country.population from CITY, country, is_member where city.population >500000 and country.code = city.country and is_member.country = country.code and is_member.organization ='eu' group by country.name, country.population having (sum(city.population) / country.population) >0.1
select city.population, country.name , city.name from CITY, country where (city.population > (select c.population from CITY c where country.capital = c.name and country.code = c.country)) and country.code = city.country
create View sym_borders as Select borders.country1 as c1, borders.country2 as c2 from borders union Select borders.country2 as c1, borders.country1 as c2 from borders