%ex3.3

\begin{enumerate}[label=(\alph*)]
	\item\textbf{Two basic queries to start with:}
	\begin{itemize}
		\item\textbf{List all the distinct countries for which addresses are
			registered in the database.}
			\begin{verbatim}
				MATCH (n:Address) RETURN DISTINCT n.countries
			\end{verbatim}
			This returns 222 different countries. We chose ''Austria''.
		\item\textbf{Choose one of these countries and list 5 entities which
			are based in that country.}
			\begin{verbatim}
				MATCH (n:Address {countries: 'Austria'})<-[r:REGISTERED_ADDRESS]-(e:Entity)
					RETURN DISTINCT e LIMIT 5
			\end{verbatim}
	\end{itemize}
	\item
		\begin{enumerate}[label=\theenumiii]
			\item\textbf{First, find the 10 \texttt{top intermediaries} , i.e.
				those 10 intermediaries that have the most outgoing
				\texttt{INTERMEDIARY\_OF} edges. Output the name of the
				intermediary as well as the number of relevant edges.}
			\item\textbf{Extend the query of i to also count outgoing
				\texttt{OFFICER\_OF} edges to determine the top intermediaries.
				Output the name of the intermediary as well as the number of
				relevant edges.}
			\item\textbf{For the top intermediary from query ii, output all the
				outgoing edges, except for those that have type either
				\texttt{OFFICER\_OF} or \texttt{INTERMEDIARY\_OF}. Also output
				the respective nodes at the other side of the edges.}
		\end{enumerate}
\end{enumerate}
