How many more times does the first word in the biwords pair "àbac-xinès" occur than the biwords pair itself?
àbac refers to word = 'àbac'; xinès refers to word = 'xinès'; How many more times the first word in the biwords occur than the biwords pair itself means SUBTRACT(words.occurrence, biwords.occurrences)
SELECT occurrences - ( SELECT occurrences FROM biwords WHERE w1st = ( SELECT wid FROM words WHERE word = 'àbac' ) AND w2nd = ( SELECT wid FROM words WHERE word = 'xinès' ) ) AS CALUS FROM words WHERE word = 'àbac'
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, 
