BaşlayınÜcretsiz Başlayın

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.```

```

Bu egzersiz

Intermediate SQL Server

kursunun bir parçasıdır
Kursu Görüntüle

Egzersiz talimatları

  • 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.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

SELECT *
FROM Kidney a
-- Create derived table: select age, max blood pressure from kidney grouped by age
JOIN (___) b
-- JOIN on BloodPressure equal to MaxBloodPressure
ON ___
-- Join on Age
AND ___
Kodu Düzenle ve Çalıştır