Darts
UPDATE darts
SET Score = CASE
WHEN x*x+y*y > 100 THEN 0
WHEN x*x+y*y > 25 THEN 1
WHEN x*x+y*y > 1 THEN 5
ELSE 10
END;
0
0
0.000
0 comments
UPDATE darts
SET Score = CASE
WHEN x*x+y*y > 100 THEN 0
WHEN x*x+y*y > 25 THEN 1
WHEN x*x+y*y > 1 THEN 5
ELSE 10
END;