Wise interview questions

The interviewer introduced his department, we then talked about the new role. After that, I was asked several questions mentioned below. We reviewed together my homework with a live test task to assess how I would handle a case. I then was asked several questions about the live test and why I handle it the way I did. We then had an open conversation about the training and skills needed in the new role.

Recruiter mailed first time, then I gave my availability, didn't receive any response. Further after a month I received a mail from recruiter that the role is still opened. He scheduled my interview with Lead Data Analyst. She gave me 3 sql questions after spending 15-20 in discussing about her, my introduction, company and SQL questions overview. I was then asked to finish all three in 20 minutes time. In the end I was told they are using some other query engine server functions and functions won't run on their server. If you are so particular about functions why not shared the server details before interview. Total wastage of time.