Pergunta de entrevista da empresa Shippo

Questions around building a web app from top to bottom, designing a system, setting up DB tables to be efficient, sorting data (from logs, for example).