I struggle with SQL interviews
I’ve been working with SQL for years and recently discovered that my issue in interviews is the terminology. For example, if an interviewer shows me an excel spreadsheet with two tables and asks me how to pull x information from it, I get nervous and end up articulating the answer very poorly, leaving out key words such as “joins”. Another example is if they asked to show it using a CTE, and this term would confuse me during the interview, but after the interview I’ll realize that I’ve written many queries that use CTEs. My question is how do I fix this? How do I prepare for such questions better? Are there any sources or tips or general advice that anyone has? I’ve not found any site that gives practice on the excel-style of questions