firsthand Software Engineer interview questions

Had two rounds. The first interviewer gave insights on the role and expectations, from having to lead Product development to day to day work. Since it was a small team this was expected. The interviewer was pleasant. Also asked some generic questions about DBT. The second round was technical focusing on a SQL challenge in Snowflake. This time around, the interviewer was not pleasant and seemed really disinterested. Throughout the interview interviewer was vaping and also did not provide a clear question and at times had to clarify. The question was straightforward and I answered it correctly. The interviewer stated I did well and explained to me what the next round will consist of and how to prepare. I was excited about this role and this company's mission and decided to prepare before the interview was finalized. I didn't hear back for a few days and reached out to the recruiter only to be told that I didn't make to the next round. I was devastated and felt as if I was mocked. Looking back at how unprofessional the interview went and the fact this was a mission driven organization, Made me question how employees are treated and more importantly, the clients they serve.