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')
How many products are not made by Sony?
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 ' )
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 = value )
How many products are not made by Sony ?