SELECT T2.Name ,  sum(T1.Num_of_stock) FROM phone_market AS T1 JOIN phone AS T2 ON T1.Phone_ID  =  T2.Phone_ID GROUP BY T2.Name
For each phone, show its names and total number of stocks.
SELECT T2.Name , sum ( T1.Num_of_stock ) FROM phone_market AS T1 JOIN phone AS T2 ON T1.Phone_ID = T2.Phone_ID GROUP BY T2.Name
select t2 . name , sum ( t1 . num_of_stock ) from phone_market as t1 join phone as t2 on t1 . phone_id = t2 . phone_id group by t2 . name
For each phone , show its names and total number of stocks .