I use free online SQL editot:

CodePudding user response：

You may force decimal division by using a decimal either in the numerator or denominator:

SELECT first_name, 9.0 / 5 AS val  -- 1.8
FROM customers;