I signed up to learn more about joins and subqueries, but I saw a disaster in the join lecture where they didn't use the join keyword and used subqueries in the where statement. Even if it's basic, shouldn't they teach you where to use and where not to use subqueries? Please take a different lecture instead of this one.