Cerillion Interview Question

OOPs concepts, string manipulation, SQL subqueries, Basic SQL