Two Labs interview questions

Recruiter reached out to me. Had two interviews, about 1/2 hour each. Seemed very unorganized, was unable to get a clear answer on some items and sounded like there would be more interviews involved. They need a clearer understanding of what the jobs are and what they're expecting and who will be in charge. My rule is if there are more than 2 interviews (on occasion 3) I decline. Communication in general was sporadic and the process was not fully defined yet. I assume it wasn't offered to me as I have heard nothing one way or the other

I was scheduled for a consulting Analyst interview with Riparian LLC. The first stage went well with two of the managers. We discussed the role and my background. The second interview was with the director. We discussed the role further in detail and what is expected. I was then scheduled for a third interview. This time it was with another manager. I was asked about some SQL questions and excel project questions. I got some of the questions wrong. A day later I was told that they are actually looking for someone with strong SQL, Data Analytics and Government pricing experience. Honestly I felt this was just huge waste of my time. If they wanted someone with these qualities, why did it take 3 stages of interviews to decide that? If I had known this is what they are looking for, I would have not taken the time out of my busy work schedule to interview with this company.