gistfile1.sql

INSERT INTO
  H_ANLAGEN_2001 ( BVDEP_ID_NUMBER, PATENTE, GOODWILL, LAND, GEBAUDE, MASCHIENEN )
SELECT
  ASSETS.BVDEP_ID_NUMBER,
  ASSETS.INTANGIBLE_FIXED_ASSETS * 0.5,
  ASSETS.INTANGIBLE_FIXED_ASSETS * 0.5,
  (EXTRA.DEPRECIATION - (0.429 * ASSETS.TANGIBLE_FIXED_ASSETS)) / 0.461 * 2 / 3,
  (EXTRA.DEPRECIATION - (0.429 * ASSETS.TANGIBLE_FIXED_ASSETS)) / 0.461 * 1 / 3,
  ASSETS.TANGIBLE_FIXED_ASSETS -
      ((EXTRA.DEPRECIATION - (0.429 * ASSETS.TANGIBLE_FIXED_ASSETS)) / 0.461))
FROM
    EXTRA
  JOIN
    ASSETS USING (BVDEP_ID_NUMBER)
  JOIN
    COMPANIES_ENTWICKLUNG USING (BVDEP_ID_NUMBER)
WHERE
    EXTRA.YEAR = ASSETS.YEAR = 2001
  AND
    COUNTRY.COMPANIES_ENTWICKLUNG = "DE"