Database: phone_market
Question: Show the names of phones that have total number of stocks bigger than 2000, in descending order of the total number of stocks.
SQL:
SELECT T2.Name FROM phone_market AS T1 JOIN phone AS T2 ON T1.Phone_ID  =  T2.Phone_ID GROUP BY T2.Name HAVING sum(T1.Num_of_stock)  >=  2000 ORDER BY sum(T1.Num_of_stock) DESC