%ex1.5

\begin{enumerate}[label=(\alph*)]
	\item SELECT distinct(displayname) FROM posts p JOIN users u ON u.id = p.owneruserid WHERE p.viewcount > u.views;

local: 45s vs 31ms

	\item SELECT score FROM comments WHERE text ILIKE 'yes\%'; <- did not work (100ms instead of 33ms)

	\item SELECT postid FROM votes WHERE postid NOT IN (SELECT postid FROM votes WHERE votetypeid != 2);

local: 16m vs 35ms
\end{enumerate}
