Pergunta de entrevista da empresa Magenic

A few whiteboard questions. SQL questions, fairly simple programming problems.