What are the names of the shops?
select shop_name from shop
Which shop has some devices in stock?
select shop_name from shop where shop_id in (select shop_id from stock)
What about no device at all?
select shop_name from shop where shop_id not in (select shop_id from stock)