Literature on quick start in SQL for a beginner in the middle (Joins, subqueries, max, aug, etc.)?

Question

SQL

Hi everyone!
At one time, SQL was not particularly needed, it was enough at the very initial level - a select with primitive operators where, ordery by, like, between, distinct)
Now there is a big need to make a tangible breakthrough in the SQL, at least they said to study joins, subqueries, max functions , rownum, and so on...
I didn’t really teach skl before, I made a couple of selects and remembered .. and how the tasks reached the level of joins with subqueries, with the calculation of the average, I swam ..
I will take advice on a quick start and the right direction, Gruber Martin advised me - Understanding SQL is not the norm? What is better than a video or a book in printed form?
How much do I want and will I be able to study it?
Thank you all for participating)

Answer 1

Martin Graber - SQL for mere mortals

Answer 2

here hady

Answer 3

At one time, SQL helped me a lot in 10 minutes. The day before the interview I was able to prepare and passed successfully.
I upvote slq-ex.ru as well, but you need at least some knowledge there.