Last answered:

13 May 2023

Posted on:

20 Jul 2021

1

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,

3 answers ( 0 marked as helpful)
Posted on:

23 Sept 2021

1

That's what I was thinking. There's deffently a misgudince here, it's either the question is wrong or the answer is wrong.

Posted on:

22 Oct 2021

0

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.

Posted on:

13 May 2023

0

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