Drop interview questions on SQL

I was asked questions on joins (like what will be the op if we do left join), window functions. Difference btw union and union all. Order of execution and other basic questions.

Focus on Joins, CTEs and Subqueries

I was asked sql questions based on window functions ( rank, cumulative sum etc) , then no.of rows forming on joining two tables in every type of joins. I interviewed for Angel one, payu, kreditbee, CoinDCX, Zepto. So mentioned an overall type which I have solved.

i have an interview for system analyst role mainly focusing on sql and unix and rn preparing for it, so drop any ques which you think i must prepare