Meta Data Engineer I interview questions

Interviewed two times in last two years. Both times same experience and same disappointments and same type of questions and same mistakes by me. Initial recruiter interview. She asked a rapid round of 5-6 SQL and programming questions and scheduled technical phone Interview which consisted 30 Min SQL and 30 min programming sessions. They use coderpad.io throughout a telephonic interview. Questions were not too difficult not too easy but the expectations were high that you keep talking and keep explaining your thought process and make it interactive session. You stumble little or not sure about something or little uncertain about a particular concept and you are gone. You are not going to make to an onsite interview. This is what happened to me. I was nervous during the start of my SQL rounds and stumbled a couple of times on easiest join problems.Beacuse of nervousness, I couldn't even think of simple join for which I write queries every day 100 times at my job. Later for programming, I recovered but I already had done damage. Interestingly I got all my answers right in both SQL and programming but still, I couldn't make to onsite. They want perfection in typing, coding, thinking. Little here and there and you miss the train. They want you to give solutions within one attempt without rewriting or rerunning solutions. So if you have that perfection then you can make it to onsite. Questions were just average and even college graduates can get solutions