Marketplace Sellers Covering Every Required Category

For each marketplace, return active sellers that offer at least one active listing in every category required by that marketplace. Ignore marketplaces with no requirements. Return marketplace_id and seller_id ordered by both columns. Return columns: marketplace_id, seller_id.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

For each marketplace, return active sellers that offer at least one active listing in every category required by that marketplace. Ignore marketplaces with no requirements. Return marketplace_id and seller_id ordered by both columns. Return columns: marketplace_id, seller_id.

Difficulty: Advanced
SQL concept: INNER JOIN