Joins
17 practice items · needed by 4 roles
Easy 5Medium 9Hard 3
Practice questions
- Rows returned by a LEFT JOINeasy
- Customers with no orderseasy
- Row count after a mergemedium
- LEFT JOIN that acts like INNER JOINhard
- Which join keeps all customerseasy
- Rows from an INNER JOINeasy
- Revenue doubled after a joinmedium
- LEFT JOIN that lost customersmedium
- Customers who never orderedmedium
- Rows after a pandas left mergemedium
- Filter inside the ON clausehard
- Row count of a LEFT JOINeasy
- Joining with a small lookup tablemedium
- WHERE filter after a LEFT JOINmedium
- Counting orders for every customermedium
- Revenue doubled after a joinmedium
- FULL OUTER JOIN row counthard