### Database Schema:
CREATE TABLE words (
	wid	INTEGER	NULL	PRIMARY KEY,
	word	TEXT	NULL,
	occurrences	INTEGER	NULL	DEFAULT 0
);

CREATE TABLE biwords (
	lid	INTEGER	NOT NULL	PRIMARY KEY,
	w1st	INTEGER	NOT NULL	PRIMARY KEY,
	w2nd	INTEGER	NOT NULL	PRIMARY KEY,
	occurrences	INTEGER	NULL	DEFAULT 0,
	foreign key (lid) references langs (lid),
	foreign key (w1st) references words (wid),
	foreign key (w2nd) references words (wid)
);

CREATE TABLE langs_words (
	lid	INTEGER	NOT NULL	PRIMARY KEY,
	wid	INTEGER	NOT NULL	PRIMARY KEY,
	occurrences	INTEGER	NULL,
	foreign key (lid) references langs (lid),
	foreign key (wid) references words (wid)
);

CREATE TABLE langs (
	lid	INTEGER	NULL	PRIMARY KEY,
	lang	TEXT	NULL,
	locale	TEXT	NULL,
	pages	INTEGER	NULL	DEFAULT 0,
	words	INTEGER	NULL	DEFAULT 0
);

CREATE TABLE pages (
	pid	INTEGER	NULL	PRIMARY KEY,
	lid	INTEGER	NULL,
	page	INTEGER	NULL	DEFAULT NULL,
	revision	INTEGER	NULL	DEFAULT NULL,
	title	TEXT	NULL,
	words	INTEGER	NULL	DEFAULT 0,
	foreign key (lid) references langs (lid)
);

CREATE TABLE pages_words (
	pid	INTEGER	NOT NULL	PRIMARY KEY,
	wid	INTEGER	NOT NULL	PRIMARY KEY,
	occurrences	INTEGER	NULL	DEFAULT 0,
	foreign key (wid) references words (wid),
	foreign key (pid) references pages (pid)
);

### User's Query:
Calculate the average number of repetitions in the pairs of words in which the first word id is number 34.

### Extra Knowledge:
Pair is a relationship of two words: w1st and w2nd, where w1st is word id of the first word and w2nd is a word id of the second word; the first word id number 34 refers to w1st = 34; repetition refers to occurrences or times this pair appears; DIVIDE(SUM(occurrences where w1st = 34), COUNT(occurrences where w1st = 34));
SELECT CAST(SUM(CASE WHEN w1st = 34 THEN 1 ELSE 0 END) AS REAL) / COUNT(w1st) FROM biwords