How many times greater is the appearances of the biword pair "a base" than "a decimal"?
a, base AND decimal are words; wid is the ID of word; w1st is the first word of a biword pair; w2nd is the second word of a biword pair; appearances refers to biwords.occurrences; biword pair 'a base' refers to word = 'a' as w1st AND word = 'base' as w2nd; biword pair 'a decimal' refers to word = 'a' as w1st AND word = 'decimal' as w2nd; appearances of 'a base' greater than 'a decimal' refers to DIVIDE(SUBTRACT(biwords.occurrences'a base', biwords.occurrences'a decimal'), biwords.occurrences'a decimal')
SELECT CAST(occurrences AS REAL) / ( SELECT occurrences FROM biwords WHERE w1st = ( SELECT wid FROM words WHERE word = 'a' ) AND w2nd = ( SELECT wid FROM words WHERE word = 'decimal' ) ) FROM biwords WHERE w1st = ( SELECT wid FROM words WHERE word = 'a' ) AND w2nd = ( SELECT wid FROM words WHERE word = 'base' )
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, 
