CREATE TABLE numbers ( num1 INT, num2 INT ); INSERT INTO numbers (num1, num2) VALUES (10, 5); INSERT INTO numbers (num1, num2) VALUES (20, 4); INSERT INTO numbers (num1, num2) VALUES (15, 3); SELECT num1, num2, (num1 + num2) AS sum_result, (num1 - num2) AS subtract_result, (num1 * num2) AS multiply_result, (num1 / NULLIF(num2, 0)) AS divide_result FROM numbers;
Made on
Tilda