I am planning to apply for finance team at Microsoft or Google with 4 years of experience and CPA. I am not sure what level of SQL do I need? Will it just me leetcode medium level questions at the interview? TC: 90k
Should know difference between internal and external joins to begin with.
do they test any sql questions during the interview?
Ask them beforehand which topics to prepare.
https://mode.com/sql-tutorial/ Go learn it. It's free, and pretty brainless to do. Takes 4 days max. And then everything else you just learn on the job, look at existing queries someone else already wrote, figure out what tables the data comes from, and then cut and paste to pull the stuff that you need. Eventually you'll see it some many times you can write your own queries blind, and honestly, once you can query your own data, that's enough for the most part. Occasionally the data team will yell at you for writing inefficient queries but you can learn about optimizing your queries then.
Finance needing SQL? Everyone in finance I know uses Excel