phone screen and coder pad.

I want to give more information about preparation and what can be done to crack the second round. LeetCode and Interview Query are not going to help. You waste time by solving problems there.

The best place to start your preparation, if you already know the basics of Python and SQL, is Glassdoor questions.

I have compiled and solved all the Python questions. I will try to attach a link to this review later.

I solved all the Python questions given. It was a repetition of the questions mentioned already on Glassdoor. What I underestimated was the time to handle all the test cases. The code you write can easily solve the problem, and it takes 6 to 8 minutes to type out the code. However, there will be 5 test cases, and the code will not handle all of them. Only if all 5 test cases pass will the next question be given.

A simple problem given to me was to replace nulls with the previous value in a list. The test cases, however, would have strings instead of lists. The first value of the list could be null, or there might be an empty list. So, your code has to handle all of these scenarios.

SQL: I wasn't great at PostgreSQL, so I couldn't reach the output even though the logic was right. Please prepare SQL coding for Glassdoor questions using PostgreSQL.

In a table, find the percentage of customers who purchased a particular product.