Wayfair Commercial Analyst interview questions

Did the OA and passed. Did the case interview went well and the interviewer told me he hopes to see me during the summer. I go 8 weeks without hearing from them. HR tells me I didn't complete the interview which is weird and makes no sense. I try sending proof of the emails she gives me the same response. atp I tell myself what do I have to lose I'm just going to do the same case twice. I do it with another guy and then 5 days later they tell me they won't be moving on with my candidacy this process dragged for almost 4 months it's really disheartening. I dont even know what I did wrong

After I applied, I was sent a HackerRank to showcase SQL skills. Then I was scheduled for a Case Study, for which I received no information, and when I joined that call, the interviewer arrived 15 minutes late, looked unprepared, and asked me what I was doing on the case study. Following that, I was scheduled for 2 interviews, and the second one was cancelled 5 minutes before I was expected to join. Overall, managers seem uninterested and quite unaware of what was going on in the interview.