SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE IF NOT EXISTS hw( id INTEGER, height FLOAT4, weight FLOAT4 ); INSERT INTO hw (id, height, weight) VALUES (1, 4, 8); INSERT INTO hw (id, height, weight) VALUES (2, 5, 2); INSERT INTO hw (id, height, weight) VALUES (3, 2, 9); INSERT INTO hw (id, height, weight) VALUES (4, 3, 4); INSERT INTO hw (id, height, weight) VALUES (5, 5, 7); INSERT INTO hw (id, height, weight) VALUES (6, 6, 3); SELECT COUNT(*) AS underweight_count FROM hw WHERE weight / 2.2046 / (height * 0.0254)^2 < 18.5;