Pregunta de entrevista de DRW

Some very down-to-earth problem on coding section, pleasantly surprised. Unfamiliar algo problem, more like medium-hard. And a data modelling exercise.