Interview was fully based on python and sql. In python some logical questions were asked and in sql some joins, window functions etc. Other than this i was also asked about my project in depth.
Interview questions [1]
Question 1
They gave me data from a company and asked me to identify rolling salaries of employees