I'm having a bit of difficulty when using SUM and MAX in oracle.

What I am trying to do is find the patient with the highest SUM of scores.

I would like to SELECT both the total score as well as the patient id.

If I run this query I get the highest score but not any of the patient details as expected.

```
        SELECT MAX(SUM(PM.score)) AS Total
        FROM Patient P, PatientMetabolic PM
        WHERE P.patientID = PM.patientID
        GROUP BY P.patientID

```

If I add patient ID like this

```
        SELECT MAX(SUM(PM.score)) AS Total, P.patientId
        FROM Patient P, PatientMetabolic PM
        WHERE P.patientID = PM.patientID
        GROUP BY P.patientID

```

I get a *not a single-group group function* error.

Any help would greatly be appreciated, thanks for your time.