CREATE TABLE products (code NUMBER, name CLOB, price NUMBER, manufacturer NUMBER)
CREATE TABLE manufacturers (code NUMBER, name CLOB, headquarter CLOB, founder CLOB, revenue NUMBER)

Find the number of manufactures that are based in Tokyo or Beijing.
SELECT COUNT(*) FROM manufacturers WHERE headquarter = 'Tokyo' OR headquarter = 'Beijing'
SELECT COUNT(*) FROM "manufacturers" WHERE "headquarter" = 'Beijing' OR "headquarter" = 'Tokyo'