SELECT LastName FROM CUSTOMER EXCEPT SELECT T1.LastName FROM CUSTOMER AS T1 JOIN Invoice AS T2 ON T1.CustomerId = T2.CustomerId WHERE T2.total > 20
CREATE TABLE CUSTOMER (LastName VARCHAR); CREATE TABLE CUSTOMER (LastName VARCHAR, CustomerId VARCHAR); CREATE TABLE Invoice (CustomerId VARCHAR, total INTEGER)
ค้นหานามสกุลของลูกค้าทั้งหมดที่ไม่มียอดรวมใบแจ้งหนี้มากกว่า 20
Find all the customer last names that do not have invoice totals larger than 20.