How the heck do I pass SQL interviews
Hi, currently an early career job seeker applying for Data Science ft and intern roles.
I've had about three live SQL interviews over the past year and I haven't passed a single one. I do SQL leetcode and online problems I find from statascratch pretty much everyday as part of a routine. I'd say I'm able to solve SQL mediums on leetcode pretty consistently. the main issue I run into is that the questions I run into in these interviews are patterns that I've never seen before and have literally no idea how to handle. Its really frustrating because I practice so much and I'm never able to perform in even basic internship interviews.
Does anyone have any good resources for learning a lot of the SQL patterns that interviewers actually use?? (I recently encountered a gaps and islands problem and I've literally never seen anything like it for example).
Thanks so much, have been struggling a lot and really would appreciate advice.