MedeAnalytics interview question

simple sql Questions on Joins, programming question on manipulating strings