2 SQL questions and one python. The job description made zero claim to require python skills. Besides the question at hand was geared towards engineering vs analysis.
The first question required basic aggregation, group by, and maybe a having statement. The big issue is you cannot run dummy code like select * from table to get a feel for the data. The second one was a question that required recursion that kept throwing errors. I was about 99% there but it kept throwing an error that wouldn't clear. Last question was 100% a data engineering question, and nothing around analysis.