WITH ALL_SUM AS (
  SELECT ALL.ID AS ID,
         SUM(ALL.BEG) AS SUM_BEG,
         SUM(ALL.END) AS SUM_END
  FROM ALL
  GROUP BY 1
)
SELECT
    DOC.STAT,
    DOC.NAME,
    DOC.CAPTION,
    DOC.DATE,
    NUM.SUM,
    ALL_SUM.SUM_BEG,
    ALL_SUM.SUM_END
FROM DOC
INNER JOIN NUM ON DOC.ID = NUM.ID
LEFT JOIN ALL_SUM ON NUM.ID = ALL_SUM.ID
WHERE DOC.CAPTION = 'работает' AND
      DOC.DATE = (SELECT
                      MAX(DD.DATE)
                  FROM DOC DD
                  WHERE DD.NAME = 'все' AND
                        DD.CAPTION = 'работает')