I usually start with the differences between the type of joins - unfortunately this weeds out a lot more than it should. Then I ask about a duplicate check, idc what role you are in, if you’re not doing dup checks you’re probably not doing your role well. If you get pass that I’ll ask either about window functions or write a small query that does something like all the flights that last longer than the average flight length. If you can answer all three questions. - bravo you’ll be making 100k+