LeetCode 1581: Customer Who Visited but Did Not Make Any Transactions [SQL]

Опубликовано: 14 Апрель 2026
на канале: Frederik Müller

5,933

134

Solution and walkthrough of a real SQL interview question for Data Scientist and Data Analyst technical coding interviews. This question is marked as easy and is called "Customer Who Visited but Did Not Make Any Transactions".

0:00 Intro
0:07 Problem Statement
1:41 Subquery (WHERE NOT IN) Solution
5:10 LEFT JOIN Solution
10:31 Problem Discussion
11:12 Outro

Try this question: https://leetcode.com/problems/custome...

Check out StrataScratch: https://www.stratascratch.com?via=fre...

Find me on LinkedIn:   / frederikmueller

Playlists:

   • StrataScratch Coding Questions [SQL]

   • LeetCode SQL 50 Study Plan

   • LeetCode Database Problems [SQL]

   • LeetCode Easy Database Problems [SQL]
   • LeetCode Medium Database Problems [SQL]
   • LeetCode Hard Database Problems [SQL]