I was referred by a friend who is an employee.

The phone interview contained two parts, each 30 minutes long, focusing on Python and SQL. I provided correct answers to both SQL and Python questions, along with justifications and time complexities.

Still, I received no offer for an onsite interview.

Reading reviews here, it seems they are interviewing a lot of candidates but not actually proceeding with hiring, which is a waste of everyone's time.

The worst part is they don't even provide a ready schema in MySQL on CoderPad to test your SQL. They just give you the table name and columns.

Q. SQL:

1. Find new customer_ids for each day in an orders table. This means you will compare each day with previous days to find customers existing on that day but not on earlier days. This is pretty straightforward.
2. Find customers who bought on two consecutive days. You would want to use the DATEDIFF function here to answer that.

PYTHON:

1. For a sorted list without duplicates, find the nth missing number. You should use binary search here.
2. Find the first non-recurring number in a list (unsorted). This is a common LeetCode question.