Eliminating effectively-redundant entries with Inner Join
SELECT ANY_VALUE(t1.nickname) nickname, t2.stipend
FROM moniker_tbl AS t1
INNER JOIN student_tbl AS t2 ON t1.name = t2.name
GROUP BY t2.name, t2.stipend;