3 \begin{enumerate}[label=(\alph*)]
4 \item SELECT distinct(displayname) FROM posts p JOIN users u ON u.id = p.owneruserid WHERE p.viewcount > u.views;
8 \item SELECT score FROM comments WHERE text ILIKE 'yes\%'; <- did not work (100ms instead of 33ms)
10 \item SELECT postid FROM votes WHERE postid NOT IN (SELECT postid FROM votes WHERE votetypeid != 2);