Databases IK-AI, 2007 (assignment 2)
	0440949 Andreas van Cranenburgh
	Tue Mar 20 13:04:30 CET 2007 

	1.4
select Name from language group by Name having count(country) > 1


	1.5
select distinct Name from country, (select Country from geo_mountain, 
	(select Name from mountain where mountain.height = (select max(Height)
	from mountain)) as highest where geo_mountain.Mountain = highest.Name)
	as hicoun where country.Code = hicoun.Country

	1.6
select River, City, Lake from located where located.river is not null and
	located.lake is not null

	1.7
Using AS:
select * from geo_mountain, (select Country from geo_mountain where 
	geo_mountain.Mountain = 'Kilimanjaro') as kili where
	geo_mountain.Country = kili.Country;

Using subquery:
select * from geo_mountain where Country in (select Country from geo_mountain
	wh
ere geo_mountain.Mountain = 'Kilimanjaro');

	1.8
insert into student values (0440949, 'Andreas van Cranenburgh', 'DBAI', 3 * PI());

	1.9}
update student set grade = 1.02 * grade where sudentnumber = 0440949

--
A quote from a mail I sent, explaining why I ommited answers in QBE:
"I wish to object to the requirement of questions 1.8 and 1.9 to give answers    
in the Query By Exasperation language. The textbook of this course does not     
cover how to insert or update rows with QBE, and neither do the slides."