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;
9
0
15.554 STEM
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;