Wolfspeed Manufacturing Programmer (.NET) interview questions

It started with a phone interview with the hiring manager, where I would just talk about my experience. After that, I had to submit a behavioral assessment and 3 professional references before attending a 3 hour on-site interview. The onsite interview consisted of multiple rounds speaking to the recruiter, managers, and potential team members. The questions were mixed with behavioral and technical ones, which involved me writing a few SQL statements and interpreting SQL and VB.Net code written for the systems and applications there. After the interview, I didn't hear back until about a month later that another candidate was chosen over me. Overall, everyone was nice and friendly except one man. This man is the hiring manager's supervisor and should have stayed out of the interview. First of all, he was about 10 minutes late and the hiring manager had to take his place until he arrived. When he arrived, he didn't even have my resume and the hiring manager had to give one to him, foreshadowing his lack of investment in the interview. The hiring manager's supervisor had an antagonistic attitude towards me, showed aggressive body language (i.e. slamming his hands on the table and waving his hands in the air in annoyance as he spoke), acted annoyed by my responses and my questions, had black-and-white thinking, and only asked questions like "Why should we hire you?" and "Why do you want to work here?" It felt more like an interrogation than an interview. Even the hiring manager, who was apparently watching us, apologized for his supervisor's behavior and suggested that he was having a bad day. Whatever the reason, he didn't seem to be in the right mindset for this interview and shouldn't have bothered with it. Maybe the interview could've been 2.5 hours instead of 3.