What proportion of a pair of words in the Catalan language have been repeated less than 80 times?
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; in the Catalan language refers to lid; repeated less than 80 times refers to occurrences < 80; DIVIDE(COUNT(lid where occurrences < 80), COUNT(lid)) as percentage;
SELECT CAST(COUNT(CASE WHEN occurrences < 80 THEN lid ELSE NULL END) AS REAL) * 100 / COUNT(lid) FROM biwords
database name:db_id language_corpus
langs table langs Cols: language id dtype integer, language dtype text, locale dtype text, pages dtype integer, words dtype integer, 
pages table pages Cols: page id dtype integer, language id dtype integer, page dtype integer, revision dtype integer, title dtype text, words dtype integer, 
words table words Cols: word id dtype integer, word dtype text, occurrences dtype integer, 
langs_words table langs_words Cols: language id dtype integer, word id dtype integer, occurrences dtype integer, 
pages_words table pages_words Cols: page id dtype integer, word id dtype integer, occurrences dtype integer, 
biwords table biwords Cols: language id dtype integer, word id of the first word dtype integer, word id of the second word dtype integer, occurrences dtype integer, 
