79161868

Date: 2024-11-06 08:55:08
Score: 0.5
Natty:
Report link

I suggest using case when, like this,

UPDATE driver
SET triptotal = (
CASE
WHEN EXISTS (
select 1 from trip
where trip.driver_id = driver.id)
THEN (
select count(*) from trip
where trip.driver_id = driver.id)
ELSE 0
END
);
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: bsraskr