DB Fiddle

SQL: Find Customers Who Have Gone Quiet with a LEFT JOIN

A beginner SQL walkthrough in the free DB Fiddle: join a customers table to orders, see why a plain JOIN hides customers who never ordered, and list every quiet account with LEFT JOIN, MAX and HAVING.

  • Free
  • No sign-up
  • 17 steps
  • ~15 min
Start the free practiceStart practicingDo every step yourself in a practice copyHands-on, ~15 min, best on a computer