Which biwords pair has a higher occurrence, "àbac-xinès" or "àbac-grec"?
higher occurrence is MAX(occurrences); àbac refers to word = 'àbac'; xinès refers to word = 'xinès'; grec refers to word = 'grec'
SELECT CASE WHEN ( SELECT occurrences FROM biwords WHERE w1st = ( SELECT wid FROM words WHERE word = 'àbac' ) AND w2nd = ( SELECT wid FROM words WHERE word = 'xinès' ) ) > ( SELECT occurrences FROM biwords WHERE w1st = ( SELECT wid FROM words WHERE word = 'àbac' ) AND w2nd = ( SELECT wid FROM words WHERE word = 'grec' ) ) THEN 'àbac-xinès' ELSE 'àbac-grec' END AS CALUS FROM words LIMIT 1
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, 
