Sum case when

Databases
7

you could also do this –

, SUM(CASE WHEN d.dec = 4 THEN COALESCE(DATEDIFF(d.date2,d.date1) ,DATEDIFF(CURDATE(),d.date1)) END) AS tD_plus_oD