Meta Data Scientist interview questions

I was referred by an employee. I was contacted by HR recruiter the next day, we talked for about 30 minutes and I had a phone technical screen planned and scheduled in less than 2 weeks. It was SQL and analytical questions. I had enough material to prepare sent by HR recruiter. Nevertheless I didn't do well: the question was not difficult but I was extremely nervous and couldn't think. The interviewer was nice and tried to help. The HR was fast and nice too.

I only experienced the phone screening. Asked about SQL and a Open ended question. The SQL question is rather easy after I've done all the leetcode questions. The open ended question is about designing a new form of ads on instagram. Asking me what I would do to determine the number of ads to on one page. I finished this one rather quickly, and then was asked a hard behavioral question: what is your weaknesses.