Altisource Business Analyst interview questions

It was an internal job posting for a business analyst role and I applied internally. it took almost a week to schedule 1st round of interview and 2nd round of interview was scheduled after 2 to 3 weeks later

1st was a SQL written test round which had 10 questions and were basic. After 5 mins , A panel of 2 members came to interview and asked basic but tricky SQL questions which was followed by a puzzle. Then I had a apti round and a. Behavioral round