def query_epo_desc_table(src_table: str):
    """
    Return the query generating the aggregate table to compute descriptive statistics on the EPO
    full text database
    :param src_table: str, table path to EPO full-text database on BigQuery e.g.
    'project.dataset.table'
    :return: str
    """
    query = f"""
    WITH
      tmp AS (
      SELECT
        publication_number AS publication_number,
        publication_date,
        title.text IS NOT NULL AS has_title,
        title.LANGUAGE AS title_language,
        abstract.text IS NOT NULL AS has_abstract,
        abstract.LANGUAGE AS abstract_language,
        description.text IS NOT NULL AS has_description,
        description.LANGUAGE AS description_language,
        claims.text IS NOT NULL AS has_claims,
        claims.LANGUAGE AS claims_language,
        amendment.text IS NOT NULL AS has_amendment,
        amendment.LANGUAGE AS amendment_language,
        url.text IS NOT NULL AS has_url,
        url.LANGUAGE AS url_language,
      FROM
        `{src_table}`)
    SELECT
      family_id AS family_id,
      tmp.*
    FROM
      tmp,
      `patents-public-data.patents.publications` AS p
    WHERE
      tmp.publication_number = p.publication_number
    """
    return query