What is the number of projects that Sony doesn't manufacture?
select count ( distinct name ) from products where name not in ( select t1.name from products as t1 join manufacturers as t2 on t1.manufacturer = t2.code where t2.name = 'Sony' )
What is the number of products that Creative Labs does manufacture?
select count ( distinct name ) from products where name in ( select t1.name from products as t1 join manufacturers as t2 on t1.manufacturer = t2.code where t2.name = 'Creative Labs' )