I was asked about different join operations and to find the top 3 in a table in SQL, along with simple coding questions for python . Ut was easy to medium level.

There was a hackerrank test for getting the interview call. The hackerrank test was followed by two rounds of interviews where medium level questions were asked. This was for the freshers.