Select Code to Download

SELECT DISTINCT c.name
FROM   customers c, orders o
WHERE  o.id = c.id
  AND  o.amount > 1000