bq002.sql

  SELECT
    c.case_id,
    c.exp__years_smoked,
    r.fpkm_unstranded
  FROM
    `isb-cgc-bq.TCGA_versioned.clinical_gdc_r37` AS c
  JOIN
    `isb-cgc-bq.TCGA_versioned.RNAseq_hg38_gdc_r35` AS r
  ON
    c.case_id = r.case_gdc_id
  WHERE
    proj__project_id IN ('TCGA-LUSC',
      'TCGA-LUAD',
      'TCGA-HNSC')
    AND exp__years_smoked IS NOT NULL