How many devices are in stock at 	Dinas Device?
select count ( device_id ) from stock as t1 join shop as t2 on t1.shop_id = t2.shop_id where shop_name = 'Dinas Device'
How many devices are at Best Buy?
select count ( device_id ) from stock as t1 join shop as t2 on t1.shop_id = t2.shop_id where shop_name = 'Best Buy'
Show me the name of the shop that has the most 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 count ( * ) desc limit 1
Where are they located?
select t2.shop_name,location from stock as t1 join shop as t2 on t1.shop_id = t2.shop_id group by t1.shop_id order by count ( * ) desc limit 1