SQL: leetcode?

I am applying for Senior Data Analyst positions, and blazing through the HR screen and first round interview. I've failed a couple of technical interviews, all SQL based. The feedback I get is that while my answers were correct, they weren't technically advanced or sophisticated.
I'm not sure what I should do to improve. While I do hate hate hate subqueries and will always prefer a CTE, I always include them in the technical assignment to show that I can …

datascience leetcode sql