Mock interview question 3
Hi Tina and team,
In order to answer this question, shall we figure out the total number of accounts, as the current solution filtered by Jan-10th only counts the accounts that have activities on that specific day?
Thanks for your time looking into my question!
Cheers,
That's what I was thinking. There's deffently a misgudince here, it's either the question is wrong or the answer is wrong.
In the beginning Tina gets confirmation that each account has an entry for every single day (indicating whether it's open or closed that day), so this method should work.
The question nor the answer is wrong, both solutions would work. Personally, I would also prefer to just sum the number of records instead of adding the closed + open, especially since each account has to be either closed or opened anyway. Seems, theoretically, less expensive.
Submit an answer
