SELECT T2.Shop_Name FROM stock AS T1 JOIN shop AS T2 ON T1.Shop_ID  =  T2.Shop_ID GROUP BY T1.Shop_ID HAVING COUNT(*)  >  1
What are the names of shops that have more than a single kind of device in stock?
SELECT T2.Shop_Name FROM stock AS T1 JOIN shop AS T2 ON T1.Shop_ID = T2.Shop_ID GROUP BY T1.Shop_ID HAVING COUNT ( * ) > 1
select t2 . shop_name from stock as t1 join shop as t2 on t1 . shop_id = t2 . shop_id group by t1 . shop_id having count ( * ) > value
What are the names of shops that have more than a single kind of device in stock ?