Question

Write a query to display the name of the company that manufactures the most number of medications. In case of multiple records, display the records sorted in ascending order based on company name.

Answer 1

 Listed pharmaceutical companies in ascending order by Market Capitalization as of July 2015, in India.
   Rank      Company                           Market Capitalization 2015 (INR crores)
   5             Aurobindo Pharma            42,454

   6              Cadila Healthcare             38,677

   4             Cipla                                  52,081

   8            Divi's Laboratories              24,847

   3         Dr. Reddy's Laboratories        63,779

   7         Glenmark Pharmaceuticals      26,026

   2          Lupin Ltd                                  84,193

   1         Sun Pharmaceutical                 2,17,636

   9         Torrent Pharmaceuticals            22,774