CREATE TABLE manufacturers (code VARCHAR(255), name VARCHAR(255)); CREATE TABLE products (name VARCHAR(255), Manufacturer VARCHAR(255))
Find the name of product that is produced by both companies Creative Labs and Sony.
    
SQL: SELECT T1.name FROM products AS T1 JOIN manufacturers AS T2 ON T1.Manufacturer = T2.code WHERE T2.name = 'Creative Labs' INTERSECT SELECT T1.name FROM products AS T1 JOIN manufacturers AS T2 ON T1.Manufacturer = T2.code WHERE T2.name = 'Sony'