Hello,
I had an interview at Facebook for a data engineer position. It was using coderpad on SQL and Python questions. from SQL questions there were joins, group by, and percentage. from python, strings, list and loops. I was able to finish 3 python codes and 2 SQL in 50 minutes. it took some time for me to understand 3rd SQL question even though it was a simple join with some where condition and find ratio. ( I imagined more than what it needs !).

lessons learned :
Think well and find a solution before you start SQL/coding. it is difficult to write the SQL and think through the problem.

I had difficulty with coderpad on my small laptop screen, I should have connected it to monitor for a better view. You have to roll up and down to see schema or edge cases.

Python coding questions were simple, like compare two string and find the word only in one string. count each letter from a string. The catch is there are few edge cases that we need to think while coding.

I felt it is easy to use CASE in SQL to create a column with 1's and 0's then take AVG to find the ratio instead of running two selects to find the percentage.

I am excited and I want to continue giving these kinds of interviews more. I believe that will help me to manage my stress during the interview.
Let me know if you find any company doing the same style (SQL and coding) interview.

Thanks