SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE weight(
  id INTEGER PRIMARY KEY, 
  date_and_time TEXT, 
  weight_in_lb INTEGER, 
  height_ft INTEGER, 
  height_in INTEGER, 
  BMI FLOAT GENERATED ALWAYS AS (weight_in_lb * height_ft * height_in * 0.001), -- custom formula because the standard distribution of SQLite does not support math functions like POWER()
  reference TEXT GENERATED ALWAYS AS (CASE WHEN BMI > 25 THEN 'OVERWEIGHT' END)
);
✓
INSERT INTO weight(id,date_and_time,weight_in_lb,height_ft,height_in) VALUES 
  (1,'4/20/2000',272,5,10),
  (2,'4/20/2000',272,50,10);
✓
SELECT * FROM weight;


id
date_and_time
weight_in_lb
height_ft
height_in
BMI
reference


1
4/20/2000
272
5
10
13.6
null

2
4/20/2000
272
50
10
136
OVERWEIGHT