I am missing something simple but I can't quite figure it out. 

I need to essentially get the Max Count of a Column. 

```
SELECT 
    S.Type AS Type, 
    S.Version, 
    COUNT(R.FK_StoveNbr) AS TimesRepaired

FROM STOVE AS S
FULL JOIN STOVE_REPAIR AS R 
ON S.SerialNumber = R.FK_StoveNbr

GROUP BY S.Type, S.Version
ORDER BY TimesRepaired DESC;

```

This gives me the information I need, but now I need to make it so it only displays the Type with the highest number from the COUNT(R.FK\_StoveNbr). 

Some information: 

```
[STOVE_REPAIR](
[RepairNbr] [int] NOT NULL,
[FK_StoveNbr] [int] NOT NULL,
[RepairDt] [smalldatetime] NOT NULL,
[Description] [varchar](500) NULL,
[Cost] [numeric](7, 2) NULL,
[FK_CustomerID] [int] NOT NULL,
[FK_EmpID] [int] NULL,

[STOVE](
[SerialNumber] [int] NOT NULL,
[Type] [char](15) NOT NULL,
[Version] [char](15) NULL,
[DateOfManufacture] [smalldatetime] NULL,
[Color] [varchar](12) NULL,
[FK_EmpId] [int] NULL,

```

Needed output:

```
 type        version   times repaired
 ---------    -----     --------------
 FiredAlways    2            2

```

The Output I have: 

```
 type            version   times repaired
 ---------        -----     --------------
 FiredAlways        2               2
 FiredAlways        1               1
 FiredNow           2               1 
 FiredNow           3               1
 FiredNow           1               1
 FiredAlways        4               0
 FiredAlways        5               0
 FiredAlways        3               0
 FiredAtCamp        3               0
 FiredAtCamp        1               0
 FiredAtCamp        2               0

```