Table: cancer_imm_treatment
Columns: antibody
brand_name
approval_date
type
target
approved_treatment_s

Question: What are all the approved treatments for the target CD30?
SQL: SELECT "approved_treatment_s" FROM cancer_imm_treatment WHERE "target" = 'CD30'

Question: What is the brand name for the antibody Brentuximab Vedotin?
SQL: SELECT "brand_name" FROM cancer_imm_treatment WHERE "antibody" = 'Brentuximab vedotin'

Question: How many targets are there with an approval date of 1997?
SQL: SELECT COUNT("target") FROM cancer_imm_treatment WHERE "approval_date" = 1997

Question: What are the approved treatments when the antibody is bevacizumab?
SQL: SELECT "approved_treatment_s" FROM cancer_imm_treatment WHERE "antibody" = 'Bevacizumab'

Question: What is the target when the approved treatment is non-hodgkin lymphoma?
SQL: SELECT "target" FROM cancer_imm_treatment WHERE "approved_treatment_s" = 'non-Hodgkin lymphoma'

Question: What is the target with an approval date of 2006?
SQL: SELECT "target" FROM cancer_imm_treatment WHERE "approval_date" = 2006