Установить стоимость контрактов, начинающихся после даты, следующей за датой выполнения запроса, в размере, на

UPDATE "Contract" SET "Price" = "Price" + ("Salary")*0.5
FROM "Positions"
WHERE "StartDate" > 'today'

UPDATE "Contract" c SET "Price" = "Price" + 0.5 * (SELECT SUM("Salary") FROM "Crew" c, "Positions" p WHERE p."YactId" = c."YactId" AND c."PositionId" = p."PositionId")
WHERE "StartDate" > 'today'

UPDATE "Contract" AS ct
  SET ct."Price" = ct."Price" + 
    0.5 * 
    (ct."EndDate" - ct."StartDate") *
    (SELECT SUM("Salary") FROM "Crew" cr, "Positions" ps WHERE cr."YactId" = ct."YactId" AND cr."PositionId" = ps."PositionId")
  WHERE "StartDate" > 'today';

SET "Price" = "Price" + 
    (0.5 * 
    ("EndDate" - "StartDate")) *
    
    ((SELECT SUM (p."Salary")
      FROM "Yacht" AS y , "Crew" AS c, "Positions" AS  p
      WHERE y."YachtId" = c."YachtId" AND c."PositionId" = p."PositionId"
      GROUP BY  y."Name"))
  WHERE "StartDate" > 'today';

UPDATE "Contract" SET "Price" = "Price" + 
    (0.5 * 
    ("EndDate" - "StartDate")) *
    
    ((SELECT SUM (p."Salary")
      FROM "Yacht" AS y , "Crew" AS c, "Positions" AS  p
      WHERE y."YachtId" = c."YachtId" AND c."PositionId" = p."PositionId"
      GROUP BY  y."Name"))
  WHERE "StartDate" > 'today';

UPDATE "Contract" AS ct
 
  SET ct."Price" = ct."Price" + 
    0.5 * 
    (ct."EndDate" - ct."StartDate") *
    
    (SELECT SUM("Salary") 
    FROM "Crew" cr, "Positions" ps 
    WHERE cr."YachtId" = ct."YachtId" AND cr."PositionId" = ps."PositionId")
    
  WHERE "StartDate" > 'today';

UPDATE "Contract" AS ct
  SET "Price" = ct."Price" + 
    0.5 * 
    (ct."EndDate" - ct."StartDate") *
    (SELECT SUM("Salary") 
    FROM "Crew" cr, "Positions" ps 
    WHERE cr."YachtId" = ct."YachtId" AND cr."PositionId" = ps."PositionId")
  WHERE "StartDate" > 'today';