Noom Technical Lead/Manager interview questions

They asked me to model a record for Noom coaches that had a primary role, but also a series of potential temporary alternative roles defined by date intervals. With this model, they asked you to create a function that would generate a report with a percentage breakdown of time spent in each role over an arbitrary date interval (presuming that time spent on any given role was exclusive).