Nexius Interview Question

basic SQL concept, join practices.