Show the top 15 companies by number of approved...

Created on Apr 6, 2025

Prompt

Show the top 15 companies by number of approved products

Chart

Query Results

SQL Query:

SELECT applicant, COUNT(DISTINCT appl_no) AS approved_products_count FROM orange_book_products GROUP BY applicant ORDER BY approved_products_count DESC LIMIT 15;

Results:

applicant	approved_products_count
WATSON LABS	895
HIKMA	567
HOSPIRA	465
CHARTWELL RX	441
SANDOZ	424
TEVA	324
FRESENIUS KABI USA	317
RISING	292
NORVIUM BIOSCIENCE	280
TARO	246
ANI PHARMS	242
STRIDES PHARMA	228
AUROBINDO PHARMA LTD	227
ENDO OPERATIONS	221
ZYDUS PHARMS	217

Chart Configuration

{
  "grid": {
    "left": "3%",
    "right": "4%",
    "bottom": "3%",
    "containLabel": true
  },
  "color": [
    "#5470c6",
    "#91cc75",
    "#fac858",
    "#ee6666",
    "#73c0de",
    "#3ba272",
    "#fc8452",
    "#9a60b4",
    "#ea7ccc"
  ],
  "title": {
    "left": "center",
    "text": "Top 15 Companies by Number of Approved Products"
  },
  "xAxis": {
    "data": [
      "WATSON LABS",
      "HIKMA",
      "HOSPIRA",
      "CHARTWELL RX",
      "SANDOZ",
      "TEVA",
      "FRESENIUS KABI USA",
      "RISING",
      "NORVIUM BIOSCIENCE",
      "TARO",
      "ANI PHARMS",
      "STRIDES PHARMA",
      "AUROBINDO PHARMA LTD",
      "ENDO OPERATIONS",
      "ZYDUS PHARMS"
    ],
    "name": "Number of Approved Products",
    "type": "value",
    "axisLabel": {
      "formatter": "{value}"
    },
    "boundaryGap": [
      0,
      0.01
    ]
  },
  "yAxis": {
    "data": [],
    "name": "Company",
    "type": "category",
    "inverse": true
  },
  "series": [
    {
      "id": "series1",
      "data": [
        "895",
        "567",
        "465",
        "441",
        "424",
        "324",
        "317",
        "292",
        "280",
        "246",
        "242",
        "228",
        "227",
        "221",
        "217"
      ],
      "name": "Approved Products",
      "type": "bar",
      "label": {
        "show": true,
        "position": "right",
        "formatter": "{c}"
      },
      "itemStyle": {
        "color": "#5470c6"
      }
    }
  ],
  "tooltip": {
    "trigger": "axis",
    "formatter": "{b}: {c}",
    "axisPointer": {
      "type": "shadow"
    }
  }
}