1. Learn
  2. /
  3. Courses
  4. /
  5. Intermediate SQL Server

Exercise

Creating CTEs (II)

In this exercise, you will use a CTE to return all the information regarding the patient(s) with the maximum BloodPressure.

Instructions

100 XP
  • Create a CTE BloodPressure that returns one column (MaxBloodPressure) which contains the maximum BloodPressure in the table.
  • Join this CTE (using an alias b) to the main table (Kidney) to return information about patients with the maximum BloodPressure.