What should my next step in learning SQL be?

I have been trying to teach myself SQL for a month or so to try and get some sort of job as a Data Analyst in the near-ish future.

I started off with Khan Academy and continued through the W3 tutorials and feel pretty comfortable with the basics of SQL and feel confident knowing where i can find answers to intermediate level queries. I started trying to get some practice on sql-practice.com and felt good about the "easy" and "medium" level queries and learned a bit about some functions that I hadn't been exposed to yet.

However, I feel like I hit a wall in where to go next. The "hard" level questions in sql-practice are showing a lot of gaps in my knowledge and understanding of how to set up more complex queries.

Any suggestions on what to do next? any larger practice projects that an entry level position may ask me to do? I see on this subreddit that there are a lot of websites recommended for learning SQL starting out but I was wondering what may be an intermediate level next step?

​

Thanks all