Data Capital Management interview questions

Some sql questions regarding joins, some features of your programing language, and maybe a higher level problem approach. They also give a take home question and give you some time to do it, maybe a weekend. They said it was a problem they recently dealt with. They later review your code and see how well you learned new material that you had time to work on and be more committed to.