I was selected for the interview after clearing the online assessment test and the technical + gamified rounds. It was an online interview on the Superset website. The interview lasted for a good 20 minutes.

The interviewer first asked me to introduce myself, then asked me to explain the project I had done and the tech stack used. I explained it nicely.

Then I was asked about what I know. I answered SQL, Python, ML, etc.

Then the interviewer started with SQL questions. It was intermediate queries using denserank, rownumber, then some theoretical database questions like schemas and fact tables. I could not answer a few questions, but it didn't create any obstruction; the interviewer asked another question.

How to find the least 7th salary of an employee?