I had a very disappointing experience with the interview process of the organization. The assigned HR delayed the process by 2-3 weeks and claims every time I tried to connect with her that she is on leave and will get back shortly. Regarding the interview process, there were 2 rounds, one was the case study round in which the interviewer asked about questions regarding a case-study on movies recommendation and past projects. Next, was the coding round in which the interviewer asked the ML projects and 2 coding problems one was python based and other was sql based. The interviewer asked me to explain the logic of the code. Both were done successfully and the interviewer seemed to be positive. Then after, when I reached to the HR, most of the time she didn't respond to my emails and calls. Even if she picks up she says she is on leave. For the 2 weeks she continuously claims to be on leave. When confronted one day, she reverted back to my email that you are not selected without any reason. My advice would be to think before talking to her regarding the similar roles since there are unwanted delays and no proper process of interview.

3 SQL questions, 1 python question on user click rate session start end time..A user session is a period of uninterrupted activity. something like this Calculate each user's average session time, where a session is defined as the time difference between a page_load and a page_exit.