Savance interview question

Create a few tables in SQL to represent a model, write a few queries. Then a basic C# test of my problem solving skills. I was given a simple string manipulation problem.