\documentclass[12pt,a4paper,portrait]{article}
\usepackage[pdftex]{graphicx}
\usepackage{vmargin}
\setpapersize{A4}

\begin{document}

\begin{center}
Databases IK-AI, 2007 (assignment 2) \\
0440949 Andreas van Cranenburgh
\end{center}

\section{1.4}
\begin{verbatim}
select Name from language group by Name having count(country) > 1
\end{verbatim}

\section{1.5}
\begin{verbatim}
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
\end{verbatim}

\section{1.6}
\begin{verbatim}
select River, City, Lake from located where located.river is not null and located.lake is not null
\end{verbatim}

\section{1.7}
Using AS:
\begin{verbatim}
select * from geo_mountain, (select Country from geo_mountain where geo_mountain.Mountain = 'Kilimanjaro') as kili where geo_mountain.Country = kili.Country;
\end{verbatim}

Using subquery:
\begin{verbatim}
select * from geo_mountain where Country in (select Country from geo_mountain where geo_mountain.Mountain = 'Kilimanjaro');
\end{verbatim}

\section{1.8}
\begin{verbatim}
insert into student values (0440949, 'Andreas van Cranenburgh', 'DBAI', 3 * PI());
\end{verbatim}

\section{1.9}
\begin{verbatim}
update student set grade = 1.02 * grade where sudentnumber = 0440949
\end{verbatim}

\end{document}
