-- Database schema
| langs : lid [ INTEGER ] primary_key , lang [ TEXT ] , locale [ TEXT ] , pages [ INTEGER ] , words [ INTEGER ] | pages : pid [ INTEGER ] primary_key , lid [ INTEGER ] pages.lid = langs.lid , page [ INTEGER ] , revision [ INTEGER ] , title [ TEXT ] , words [ INTEGER ] | words : wid [ INTEGER ] primary_key , word [ TEXT ] , occurrences [ INTEGER ] | langs_words : lid [ INTEGER ] langs_words.lid = langs.lid , wid [ INTEGER ] langs_words.wid = words.wid , occurrences [ INTEGER ] | pages_words : pid [ INTEGER ] pages_words.pid = pages.pid , wid [ INTEGER ] pages_words.wid = words.wid , occurrences [ INTEGER ] | biwords : lid [ INTEGER ] biwords.lid = langs.lid , w1st [ INTEGER ] biwords.w1st = words.wid , w2nd [ INTEGER ] biwords.w2nd = words.wid , occurrences [ INTEGER ] |
-- -- Among the biwords pairs with "àbac" as its first word, how many of them have an occurrence of over 10?

SELECT COUNT(T2.w2nd) FROM words AS T1 INNER JOIN biwords AS T2 ON T1.wid = T2.w1st WHERE T1.word = 'àbac' AND T2.occurrences > 10;