I have the following SQL Database structure:

![Database model](https://i.stack.imgur.com/GKpwr.png)

Users are the registered users. Maps are like circuits or race tracks. When a user is driving a time a new time record will be created including the userId, mapId and the time needed to finish the racetrack.

I wish to create a view where all the users personal bests on all maps are listed.

I tried creating the view like this:

```
CREATE VIEW map_pb AS
SELECT MID, UID, TID
FROM times
WHERE score IN (SELECT MIN(score) FROM times)
ORDER BY registered

```

This does not lead to the wished result.

Thank you for your help!