I recently tried my hand at an advanced online SQL test for a io position.
Time-trial, non-autocompleting IDE, no human interaction.
I failed miserably (0%) and I am fine with it.
I have prepared myself with StrataScratch and the Mode tutorial, on top of my experience in querying GA4 data in BQ and other data for finance, sales and operations. .
Although the resources are good to familiarize with SQL functions and structuring queries, I still feel that I am missing some kind of mindset that would enable me to tackle SQL questions irrespective of complexity.
I don't want to know necessarily the details, if it is hard for you to explain, but I would like to know if there is such a state of mind to achieve.
Of course, any description and resource is welcome.