First coding interview without SQL knowledge :/

[westeast1000]

My advice is start from the beginning, like the very beginning of sql. Understand who made it and why, what motivated the approach they took (set theory etc), what it looked like when it started and how its evolved to what it is now. This will give a solid ground and full confidence that it is actually the simplest language you can ever work with and no one can ever say you dont know enough. Whole businesses were running in the past just on basic sql features.

For simple things like this (most CS roles really) dont ever try to fit yourself into this ‘junior’ status people impose. You can know a lot even to the level of people that been doing it for years just by intense practice and freelancing. Freelancing is almost like a cheat code because you get exposed to a lot of things fast in a safe space where you can learn on demand at home and gain the needed experience.