OnePay Analytics Engineer interview questions

I applied online and the recruiter reached out to me and scheduled the first round of interview. The first round was with the hiring manager in the US. She asked me about my experience skills and the kind of situations that I had faced while working as a data engineer & how I was able to navigate through them. It was just an initial screening the I had a proctor led SQL online assessment test. First her asked some questions on SQL like constraints and joins etc that I had to write query for the given problems. The questions looked simple but very tricky. I had difficulty in connecting the question and expected output where I took lot of time. You are given only limited time per question but I couldn't get the desired output & got rejected.