Select all cities were no one in the city has purchased a book in French

03.sql

-- Returns CID's of customers that have never purchased a book in French
-- I need something like 
-- SELECT C3.city FROM yrb_customer C WHERE c3.cid = c2.cid 
-- (this doesn't work though)

SELECT DISTINCT C2.cid
FROM
	yrb_customer C2,
	yrb_purchase P, 
	yrb_book B
WHERE 
	P.cid = C2.cid AND 
	P.title = B.title AND
	P.year = B.year
EXCEPT
SELECT DISTINCT C.cid
FROM
	yrb_customer C,
	yrb_purchase P, 
	yrb_book B
WHERE 
	P.cid = C.cid AND 
	P.title = B.title AND
	P.year = B.year AND
	B.language = 'French';

Error:

SELECT DISTINCT C.city FROM yrb_customer C, WHERE C.cid NOT IN ( SELECT C2.cid FROM yrb_customer C2, yrb_purchase P, yrb_book B WHERE P.cid = C2.cid AND P.title = B.title AND P.year = B.year AND B.language = 'French')
SQL0104N An unexpected token "." was found following "_customer C, WHERE C".
Expected tokens may include: "HAVING". SQLSTATE=42601

SELECT DISTINCT C3.city 
FROM (
    SELECT DISTINCT C2.cid
    FROM
        yrb_customer C2,
        yrb_purchase P, 
        yrb_book B
    WHERE 
        P.cid = C2.cid AND 
        P.title = B.title AND
        P.year = B.year
    EXCEPT
    SELECT DISTINCT C.cid
    FROM
        yrb_customer C,
        yrb_purchase P, 
        yrb_book B
    WHERE 
        P.cid = C.cid AND 
        P.title = B.title AND
        P.year = B.year AND
        B.language = 'French';
) AS Customer
JOIN yrb_customer C3 ON C3.cid = Customer.cid;