Brillio interview question

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