Division by Zero causes an error for everything - Division by zero - Wikipedia
If your data can contain 0 in a column you want to use as a divisor then you need to defensively code for that scenario.
For example if I have a table "Table2" with two numeric columns "Value1" and "Value2" instead of a query
SELECT Value1 / Value2)
I can use
SELECT iif(Value2 = 0, 0, Value1 / Value2)
The IIF function
] is essentially the equivalent of using