what is the difference between basic and intermediate?
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).