Display patient information (patient_id, weight, height, BMI), where BMI is shown as '0' or '1' depending on whether weight(kg)/(height(m))^2 >= 30. If a patient has no weight or height yet, BMI is shown as 'N/A'. In the patients table, weight is in kg and height is in cm, and there are no cases where weight = 0. The displayed list is sorted by patient_id in ascending order; the column names and order must match the expected output.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Handle the missing-data case first, then compare the calculated BMI with the threshold.