bq028.sql

SELECT 
    `isb-cgc.TARGET_hg38_data_v0.RNAseq_Gene_Expression`.case_barcode,
    `isb-cgc.TARGET_hg38_data_v0.RNAseq_Gene_Expression`.HTSeq__FPKM_UQ,
    `isb-cgc.TARGET_hg38_data_v0.RNAseq_Gene_Expression`.Ensembl_gene_id,
    `isb-cgc.TARGET_hg38_data_v0.RNAseq_Gene_Expression`.gene_name,
    `isb-cgc.TARGET_bioclin_v0.Clinical`.CR_status_at_end_of_course_1,
    `isb-cgc.TARGET_bioclin_v0.Clinical`.CR_status_at_end_of_course_2
FROM 
    `isb-cgc.TARGET_hg38_data_v0.RNAseq_Gene_Expression`
JOIN 
    `isb-cgc.TARGET_bioclin_v0.Clinical`
ON 
    `isb-cgc.TARGET_hg38_data_v0.RNAseq_Gene_Expression`.case_barcode = `isb-cgc.TARGET_bioclin_v0.Clinical`.case_barcode
WHERE 
    `isb-cgc.TARGET_bioclin_v0.Clinical`.disease_code = 'AML'
LIMIT 100;