SQL USE OF CASE

PHOTO EMBED

Thu Aug 10 2023 09:51:01 GMT+0000 (Coordinated Universal Time)

Saved by @austin 

SELECT patient_id, weight, height, 
  (CASE 
      WHEN weight/(POWER(height/100.0,2)) >= 30 THEN
          1
      ELSE
          0
      END) AS isObese
FROM patients;
content_copyCOPY