Database: solvency_ii
Question: Show the names of products and the number of events they are in, sorted by the number of events in descending order.
SQL:
SELECT T1.Product_Name ,  COUNT(*) FROM Products AS T1 JOIN Products_in_Events AS T2 ON T1.Product_ID  =  T2.Product_ID GROUP BY T1.Product_Name ORDER BY COUNT(*) DESC