-- 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 ] |
-- -- What is the total pages of Wikipedia in Catalan language?

SELECT pages FROM langs WHERE lang = 'ca';