I have 2 tables `Corporations` (business\_id,corp\_name) and `Positions` (business\_id, salary, location)`

> 
> I'm trying to find the name of the corporation with the highest paid
>  position in a specific location.
> 
> 
> 

ex. What corp has the highest paid position in Orlando? (I just want the Corp name and Salary to show up like (NASCAR, 90000))

```
SELECT MAX(salary)
FROM Positions
WHERE location = 'Orlando'
GROUP BY compid

```

However instead of 1 result I get all corporations and their position salary for Orlando.