MySQL casts the result of integer division to a Decimal, but SQLite treats it as an integer and rounds down.  Since SQLite calls its decimal/float types "REAL" instead of "DECIMAL", accommodate both by multiplying the numerator by 1.0 to force the entire expression to a float/decimal type.
MySQL casts the result of integer division to a Decimal, but SQLite treats it as an integer and rounds down.  Since SQLite calls its decimal/float types "REAL" instead of "DECIMAL", accommodate both by multiplying the numerator by 1.0 to force the entire expression to a float/decimal type.
sbnoemi/notorhot,sbnoemi/notorhot