Exercise

Queries with derived tables (II)

In this exercise, you will create a derived table to return all patient records with the highest BloodPressure at their Age level.```

```

Instructions

100 XP

Create a derived table
- returning Age and MaxBloodPressure; the latter is the maximum of BloodPressure.
- is taken from the kidney table.
- is grouped by Age.
Join the derived table to the main query on
- blood pressure equal to max blood pressure.
- age.