Datacom Systems interview question

1. One algorithm question 2. One SQL question 3. Code to review and change using best practices 4. Talk on a video about a system designing and best practices.