3 rounds of interview asking sql, product case study and some random questions about technology and product. Resume discussion is also there. questions like what happens when a web link is clicked. how will u make sure your lazy roommate always keeps his wardrobe organized

there were 3 rounds of interview. the interviewer of last round (CTO) seemed to be confused and was not aware of what profile the interview is scheduled for. he haphazardly asked few questions and wrapped up. then a new round was scheduled which i cleared but offer letter was never issued inspite of multiple requests.