Not convinced with the solution. Eg: say we have 2 records : 1,2 and 1,3 for user 1 and 2 columns respectively. User 1 will have 2 messages. But user 2 and 3 will also have a message each. In the video approach, only 2 messages of user 1 will be counted. In fact, this approach will succeed if the records contain double counting
I'm just wondering if number of conversations here represents distinct users a person interacted with. I might only be interested in conversations a user had per day. Other than that I think the solution was to the point.
So, I'm learning SQL and just want to ask a question. How can you count all distinct instances of user 2 as being representative of all conversations. Why not have the number of conversations be based off a distinct count of concatenated user columns?
part of the difficult interview is when there is a heavy accent guy where you might need to ask "I'm sorry can you repeat your question again, then the guy got annoy and just disqualify you for the interview" .
Not convinced with the solution. Eg: say we have 2 records : 1,2 and 1,3 for user 1 and 2 columns respectively. User 1 will have 2 messages. But user 2 and 3 will also have a message each. In the video approach, only 2 messages of user 1 will be counted. In fact, this approach will succeed if the records contain double counting
I wonder if the definition of a number of conversations is the total number of msg_count or number of people someone interacts with in a day.
I'm just wondering if number of conversations here represents distinct users a person interacted with. I might only be interested in conversations a user had per day. Other than that I think the solution was to the point.
Wow, the interviewee didn't pause to contemplate the question at all before jumping into the code..
So, I'm learning SQL and just want to ask a question. How can you count all distinct instances of user 2 as being representative of all conversations. Why not have the number of conversations be based off a distinct count of concatenated user columns?
Or just take the id?
Jay I am a member of Interview Query. Where exactly can I find these interview questions?
www.interviewquery.com/questions/conversations-distribution
@@iqjayfeng Thank you
which platform is it? for practising these questions
www.interviewquery.com/
He didn’t answer the question.
So hard to understand what the interviewee was murmuring throughout the whole interview...
part of the difficult interview is when there is a heavy accent guy where you might need to ask "I'm sorry can you repeat your question again, then the guy got annoy and just disqualify you for the interview" .