Brillio Interview Question

basic SQL in a tricky way ! joins , group by vs distinct, full text index