WHICH SHOP HAS THE LARGEST QUANTITY OF DEVICES 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 order by sum ( t1.quantity ) desc limit 1
WHAT IS THE LOCATION OF THIS SHOP
select t2.location from stock as t1 join shop as t2 on t1.shop_id = t2.shop_id group by t1.shop_id order by sum ( t1.quantity ) desc limit 1
YES
select t2.shop_id from stock as t1 join shop as t2 on t1.shop_id = t2.shop_id group by t1.shop_id order by sum ( t1.quantity ) desc limit 1