A few quick questions, before you can hit the beaches.

How would you design a recursive directory file listing utility?

Implement a CONCAT function for SQLite, that can concatinate any number of values