Cerillion interview question

OOPs concepts, string manipulation, SQL subqueries, Basic SQL