db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

One answer, three ways

The same question can be written several ways. For customers with an order: IN, EXISTS, and JOIN with DISTINCT.

task

Customers with at least one order, written three times in this order: IN, EXISTS, JOIN with DISTINCT. All three return the same rows.

hints