Getting everything ready for you…

Loading courses, problems and your progress. This takes just a moment.

0s

SQL practice › Joins & grouping

Repeat Customers

Hard · Joins & grouping

Return the name and the number of delivered orders of customers who have at least 2 delivered orders, most orders first (ties by name A–Z).

Hint

Filter groups with HAVING.

Write your query on this page — it runs against the sample company database in your browser and is checked instantly.