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.

Follow this topic

Aaron Sun

Last answered:

22 Oct 2021

Posted on:

20 Jul 2021

Mock interview question 3

in SQL for Data Science Interviews / Mock Interview 3

2 answers ( 0 marked as helpful)

Abdulmalik Alkhamis

Posted on:

23 Sept 2021

Julianne Kelso

Posted on:

22 Oct 2021

Mock interview question 3

Submit an answer

related questions