Contacted me 1 month after application. 1st technical interview 10 questions on c#, SQL and Angular in HackerRank max 5 hours. 2nd technical interview through video on c# and SQL, questions were the kind which in real work we would just run the code and see the output, if it's not this it's that, should've asked some questions about working experience, past projects or theory like what problem does message queue solve. HR didn't proactively explain the process, just here's a test, here's a interview, here's another interview.

Given product table [ProductId, Name] having records [1, Apple,], [2, Orange], [3, Pear]

And order table having [ProductId, Quantity] having records [1, 7], [2, 8] only, what's the query to produce [ProductId, Name, Quantity], [1, Apple, 7], [2, Orange, 8], [3, Pear, 0].