Assume that there are no cases where height is equal 0.Calculate the BMI of each patient and return the columns: patient_id, first_name, height, weight, BMI. BMI is rounded to 1 decimal place, using the formula weight(kg) / (height(m))^2. The weight column is in kg and the height column is in cm. The displayed list is sorted by patient_id in ascending order, the column names and order must match the expected output exactly.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Beware of integer division, and of converting centimeters to meters.