79595075

Date: 2025-04-27 13:35:34
Score: 1.5
Natty:
Report link

I use this variant for displaying fake registrations not followed by orders:

SELECT c.lastname
FROM oc_customer c
WHERE NOT EXISTS (SELECT 1
                  FROM oc_order o
                  WHERE o.lastname = c.lastname
                 )
ORDER BY c.lastname;
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: Roger Greaves