if(field1 > 0,field2 / field1,0)

if (field1 > 0)
then return field2 / field1 as field3
else return 0 as field3

SELECT field1,field2,CASE
    WHEN field1>0 THEN field2/field1
    ELSE 0
  END 
  AS field3
FROM test