pretty standard interview process. 1 recruiter screen, 1 hiring manager screening, 4 rounds of loop. followed by the recruiter close out call. They offered lower pay than I am currently getting paid. So, declined the offer

I applied through a referral. First round was with a director. Good technical discussion and Medium LC SQL Queries. He did help when I was stuck and cleared that round. For second round, it was more technical discussion about previous experience and some technical questions related to pipelines and dashboards. 4 questions on hackerank. I was able to solve all the queries and the discussion too seemed good, but I could not clear the round. I got feedback and 1 of the points said inability to solve SQL queries; I am truly confused why the interviewer would say that even when I solved them all immediately.