TD Business Analyst interview questions

I applied online. Then was contacted by a recruiter. She told me there would be one interview planned and then possibly another with the team. I ended up doing four interviews, one of them being a case interview. Also, she told me after the interview, she'd send over the offer but she never did. She never got back to me. I'm very disappointed considering she led me to believe the job was mine.

The job was for reporting service department which, they created reported based on the output of other departments. First, the interviewer explained a little bit about their department and the job. After that, there was a writing test in 2 part first part was about writing queries in SQL, most of the questions were quite easy but a little bit tricky. The second part was a test about BA definition knowledge. Finally, the interviewer asked questions about my background. It was a long interview.