I had a chat with the recruiter and then the hiring manager. The hiring manager fired many questions, but in my opinion, I answered all of them correctly.

For only one question, instead of a self-join, I answered recursive CTE and subquery. Except for that, I think it went pretty well.

Right before the interview, my phone had an issue, but the interviewer was kind enough to call me for the third time, and I really appreciate that.

I got rejected after the chat with the hiring manager, and even after asking for any particular positive/negative feedback, the recruiter didn't even bother to get back to me, which I certainly do not appreciate.

Tell me about a few projects that you have worked on.

Find out which employee reports to which manager.

Subscription_id, address, subscription_date 1, ABC, 01-01-2011 2, ABC, 02-01-2012 3, XYZ, 03-03-2013

What is wrong with the above table and how would you maintain it?

Take one data metric and tell me how you maintain it.

Customer_id, check_id (combination of customer id and check id) 1, 11 1, 12 1, 13 1, 14 1, 15 2, 21 2, 22

If a record is missing in the above table, how will you find it out?