ค้นหาชื่อผลิตภัณฑ์ที่ผลิตโดยทั้งบริษัท Creative Labs และ Sony ไม่จำเป็นต้องใช้ตารางทั้งหมด
Find the name of product that is produced by both companies Creative Labs and Sony.It is not neccessary to use all the tables.
 manufacturers:  (code [ VARCHAR ] name [ VARCHAR) ]
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'