Merkle Data Scientist interview questions

Got a call from staffing agency, she asked lot of details including hobbies. Then shared one test link which contained only mcqs regarding SQL and stats. After completing the assessment straight away they called for an virtual tech round. It was an horrible experience ever for me. Initially when I gave the intro, that moment only interviewer didn't show any interest. Then he shared two SQL questions I wrote the queries with window functions , I know the answers are correct but he still asked me to write another solution for the same question. For. Programming you can't expect the same answer from everyone. Each will be having different way of approaching the problem same I did. But he literally tried to corner me. Then when it comes to ML I clearly explained the steps. But at the last I got the mail from hr saying that I haven't selected in the round 1. Kindly request if you already have someone , please don't give false hope to other candidates. The moment I received the mail from hr about my rejection, it's a heartbreak for me. Because I know that I have answered more than 80%.