Heights Finance SQL Report Developer/Data Analyst interview questions

I was selected as an interviewee through a recruiter. When I arrived, I had to wait for the individual to interview me. After 30 minutes, I was told the individual forgot about the interview. The interview was done by another individual who was not prepared for the interview. The interview was fairly easy, mostly a conversation about the role. After an hour, the interviewer arrived and I spent 5 minutes speaking with the individual. A few weeks later, I was informed by the recruiter that the role was being re-evaluated and the position was no longer available. I was pretty upset as they wasted my time preparing for the interview yet was late and I also had to take time off to go to the interview only later to find out that the role was re-evaluated and turned into another role.