The interview had multiple rounds, with each round being of the same importance.
Emphasis was on basics of SQL, a case study and guesstimates.
Multiple rounds were there to see the cultural fit with one round with the CEO himself. They wanted to know my career goals and how they could help/ fit in achieving those. Overall a really pleasant experience.