Hello!  Can you show me a list of all of the shop names?
select shop_name from shop
Beautiful!  Can you update this list to include the stock quantity for all of these shops?
select t2.shop_name,t1.quantity from stock as t1 join shop as t2 on t1.shop_id = t2.shop_id
Can you filter this list to show the name of the shop that has the largest quantity of stock, and please also display the quantity of stock?
select t2.shop_name,t1.quantity 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