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

[@curiously-cinnamon]

This is the first question in SQL 50 that I wasn't able to solve right away. Thanks for your helpful video. Now I know how to approach these kinds of problems

[@andresjvazquez]

Thank you so much for sharing with us aspiring engineers Frederik! I'm 16 and in High School, where SQL isn't really taught as much as it should be

[@frederikmuller]

That’s awesome! And yes, SQL isn’t taught enough even at university which is why I made this channel. You’re definitely set up for success if you start practicing this early in your life!

[@abhishekpandey190]

What is issue in this Ms SQL server (output is same except order) >>
Select v.customer_id,count(v.visit_id) as count_no_trans
from Visits as v
right join Transactions as t on t.Visit_id=v.Visit_id
where t.transaction_id is null
group by v.customer_id

[@gazart8557]

I thought you already made this before? Anyway still good and as usual I'm among the first few to comment haha
Plz finish the stratascratch series also

[@frederikmuller]

I think there was a similar question about transactions before 🤔
Good to know people are interested in more StrataScratch questions, as well.

[@immortal-human]

use dark mode plz

[@frederikmuller]

ok I’ll try