Question: what is the difference between intermediate and basic?
Answer: Basic: Proficient with all clauses, and can write normal queries (several joins). Intermediate: Proficient with a variety of functions, and can write advanced queries (many joins and subqueries).