Meta Data Engineering, Analytics (University Grad) interview questions

Recruiter reach out when I was doing my internship as a Data Scientist. One month later I had my phone around which was straight forward about the basics of SQL and Coding in yes or no or just one-word answers. I gave all the answers correct. Within 2 hours I got an invite for the next round which was a coding interview. I prepared too hard to be honest and as I will be working as a Data Scientist full-time next year, I was confident enough. However, my questions were totally different from what others have mentioned 3 Python questions and 3 SQL questions but I completed all questions for Python but could not solve all SQL questions due to time. (I did 2 out of 3). Coderpad is not good with the SQL interface and it was too difficult for me to run the codes because of lack of interpretability. SQL questions were medium difficulty with a little bit of twist. For my first questions, it was a pretty straight forward Percentage % question however I was getting an error without a clear explanation. I used advance select statements and then CTEs but was keep on getting an error which was later resolved by multiplying 1.0 at the end. I wasted 15 minutes on that single question. Interview questions were difficult and different than normal questions. However, the Coderpad interface is very bad. I could have done all the questions with normal interface but yeah cover pad is challenging to work on. My advice would be to practice on the coder pad for SQL questions as much as you can. Because it does not matter how much you know, its all about many questions you can do in 1 hour. I just gave 2nd round an hour ago and wanted to share my experience with everyone. I might get rejected due to not answering all the questions. But again I wished they had a different interface and clear question statements. All the questions were doable. All the best you have an interview lined up with facebook.