• A study carried out jointly by the German stock exchange and Clearstream has clearly shown that overall transaction costs resulting from barriers amount to some EUR 4.3 billion.
• Exempelvis har en undersökning som gjorts av den tyska börsen och Clearstream tydligt visat att de totala kostnaderna på grund av hindren vid transaktionerna utgör ungefär 4,3 miljarder euro.

• A survey carried out by the Commission in 1998 on the ERASMUS Programme, covering 10,000 students, showed that less than 50% of the available places were actually taken up on a full-time basis and that over 60% of the students who took those courses encountered financial difficulties.
• En undersökning som gjordes av kommissionen år 1998 om Erasmus-programmet och som omfattade 10 000 studenter visade att mindre än 50 procent av de tillgängliga platserna verkligen utnyttjades på heltid och att över 60 procent av de studenter som gick dessa kurser stötte på finansieringsproblem.

• That is why I am here today and I think we should bear in mind the assessment which has been carried out by the Mozambican Government of damage, something around 30 million US dollars, and therefore I would like to ask the Commission to take action on this matter and also - since the Commission is here, to give us an idea about the possibilities of taking action in this field in general.
• Detta är det ärende som presenterats här och vi kan särskilt beakta den uppskattning av skadorna som gjorts av den mozambikanska regeringen och som pekar på något i stil med 30 miljoner dollar, den fråga som jag skulle vilja ställa här är om man å ena sidan kan be kommissionen att ingripa, men också huruvida - nu när vi har kommissionen här - den kunde ge oss en uppskattning av vilka möjligheter som finns till åtgärder.

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 = 14380 AND
				         t12.lemma_id = 6140 AND
				         t21.lemma_id = 2855 AND
				         t22.lemma_id = 3216),
	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;
;