DataDriven
LearnPracticeInterviewDiscussDailyJobs

Find all user-product combinations where the user has never purchased that product (gap analysis)

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain
SQL
Difficulty
medium

Problem

Find all user-product combinations where the user has never purchased that product (gap analysis). Return username and product_name, ordered alphabetically.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.

Related

  • All Practice Problems
  • Mock Interview Mode
  • SQL Interview Questions
  • Data Engineering Interview Prep Guide
  • Daily Challenge
  • Data Engineering Lessons