Frage im Vorstellungsgespräch bei Savance

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.