now show me the shops that have more than one 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
shops that have more than one device in stock refers to HAVING COUNT(*) > 1;