SELECT customer FROM orders WHERE shipped = 'no' AND customer NOT IN (SELECT customer FROM orders WHERE shipped = 'yes' GROUP BY customer) GROUP BY customer ORDER BY customer