Creating CTEs (II)
In this exercise, you will use a CTE to return all the information regarding the patient(s) with the maximum BloodPressure.
Questo esercizio fa parte del corso
Intermediate SQL Server
Istruzioni dell'esercizio
- Create a CTE
BloodPressurethat returns one column (MaxBloodPressure) which contains the maximumBloodPressurein the table. - Join this CTE (using an alias
b) to the main table (Kidney) to return information about patients with the maximumBloodPressure.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
-- Create the CTE
WITH ___
AS (___)
SELECT *
FROM Kidney a
-- Join the CTE
___
___