• These enlargements alone would require the cohesion policy budget to be increased by EUR 150 billion.
• Bara dessa utvidgningar skulle kräva att budgeten för sammanhållningspolitiken ökade med 150 miljarder euro.

• In less than one decade, between 1990 and 1999, the number of women over 65 has increased by nearly 3%.
• På mindre än ett decennium, mellan 1990 och 1999, har den kvinnliga befolkningen över 65 år ökat med nära tre procent.

• Well, police resources have to be increased perhaps by 1-2% of GDP at national level in order to roll back this phenomenon.
• Ja, de polisiära resurserna måste kanske öka med 1-2 procent av BNP på nationell nivå för att rulla tillbaka denna organiserade brottslighet.

• The appropriation for Asia, where most poor people live, has increased by EUR 37 million over the previous year.
• Anslaget för Asien, där flest fattiga bor, har ökat med 37 miljoner euro jämfört med föregående år.

• By 2004, the European Union’s population will have grown by 30%, but its GNP will only increase by 4.5%.
• År 2004 kommer unionen att ha 30 procent fler medborgare, men dess BNI kommer bara att öka med 4,5 procent.

• The 20-30 age group will decrease by 9.4 million people, whilst the 50-60 age group will increase by 5.5 million.
• Befolkningen i åldern 20-30 år kommer att minska med 9, 4 miljoner individer, medan befolkningen i ålder 50-60 år kommer att öka med 5, 5 miljoner individer.

• It is estimated that 3.7 million jobs can be created by 2020, and that annual gross domestic product (GDP) can be increased by around EUR 800 billion by 2025.
• Det uppskattas att 3,7 miljoner arbeten kan skapas till 2020 och att bruttonationalprodukten (BNP) kan ökats med omkring 800 miljarder euro till 2025.

• For example, with regard to rice, he knows that the subsidy price has been reduced by 60%, that internal production has stabilised and that consumption has increased by 20%.
• När det gäller risproduktionen till exempel, vet ni att interventionspriset har minskat med 60 procent, att den interna produktionen har stabiliserats och att konsumtionen har ökat med 20 procent.

• We are not considering this at this moment in time, Ms Quisthoudt, because, as regards the EU-US trade relationship, an earlier study conducted by DG Trade on non-tariff measures shows that non-tariff barriers remain the major obstacle in EU-US trade relations and concludes that the GDP of the EU and the US would increase by about EUR 160 billion and exports would grow by 2.1% and 6.1% respectively if half of the non-tariff measures and regulatory differences were removed.
• Undersökningens slutsats är att bruttonationalprodukten i EU och USA skulle öka med omkring 160 miljarder euro och exporten skulle öka med 2,1 procent respektive 6,1 procent om hälften av de icke-tariffära åtgärderna och de reglerande skillnaderna togs bort.

SET search_path TO f9miniensv;

WITH
	list AS (SELECT
		         t11.token_id AS t11,
		         t12.token_id AS t12,
		         t21.token_id AS t21,
		         t22.token_id AS t22,
		         r1.dep_id AS dep1,
		         r2.dep_id AS dep2
		         FROM
			         deprel r1
			         JOIN depstr s1 ON s1.dep_id = r1.dep_id
			         JOIN word_align a1 ON a1.wsource = r1.head AND a1.wsource < a1.wtarget
			         JOIN word_align a2 ON a2.wsource = r1.dependent
			         JOIN deprel r2 ON r2.head = a1.wtarget AND r2.dependent = a2.wtarget
			         JOIN depstr s2 ON s2.dep_id = r2.dep_id
			         JOIN token t11 ON t11.token_id = r1.head
			         JOIN token t21 ON t21.token_id = r2.head
			         JOIN token t12 ON t12.token_id = r1.dependent
			         JOIN token t22 ON t22.token_id = r2.dependent
		         WHERE
				         s1.val = 'prep' AND
				         t11.ctag = 'VERB' AND
				         t21.ctag = 'VERB' AND
				         t12.ctag = 'ADP' AND
				         t22.ctag = 'ADP' AND
				         t11.lemma_id = 4036 AND
				         t12.lemma_id = 6140 AND
				         t21.lemma_id = 256 AND
				         t22.lemma_id = 57357),
	stats AS (SELECT
		          sentence_id,
		          count(DISTINCT token_id) AS c,
		          count(*) AS c_aligned,
		          count(DISTINCT wtarget) AS c_target
		         FROM
			         token
			         LEFT JOIN word_align ON wsource = token_id
		         WHERE
				         sentence_id IN (
					                        SELECT sentence_id
						                        FROM
							                        list
							                        JOIN token ON token_id IN(t11, t21)
					                        )
		         GROUP BY sentence_id),
	numbered AS (SELECT row_number() OVER () AS i, *
		         FROM
			         list),
	sentences AS (SELECT *, .2 * (1 / (1 + exp(max(c) OVER (PARTITION BY i) - min(c) OVER (PARTITION BY i)))) +
			                        .8 * (1 / log(avg(c) OVER (PARTITION BY i))) AS w
		         FROM
			         (
				         SELECT i, 1 AS n, sentence_id, ARRAY[t11,t12] AS tokens
					         FROM
						         numbered
						         JOIN token ON token_id = t11
				         UNION SELECT i, 2 AS n, sentence_id, ARRAY[t21,t22] AS tokens
					         FROM
						         numbered
						         JOIN token ON token_id = t21
				         ) x
			         JOIN stats USING (sentence_id)
		         ORDER BY i, n)
	SELECT
		i,
		n,
		w,
		c,
		c_aligned,
		c_target,
		sentence_id,
		string_agg(CASE WHEN lpad THEN ' ' ELSE '' END || '<span class="token' ||
			           CASE WHEN ARRAY[token_id] <@ tokens THEN ' hl' ELSE '' END || '">' || val || '</span>',
		           '' ORDER BY token_id ASC) AS s
	FROM
		sentences
		JOIN token USING (sentence_id)
		JOIN typestr USING (type_id)
	GROUP BY i, n, w, c, c_aligned, c_target, sentence_id
	ORDER BY w DESC, i, n;
;