Table: cancer_immunotherapy
Columns: antibody
brand_name
approval_date
type
target

Question: What's the target of the antibody rituximab?
SQL: SELECT "target" FROM cancer_immunotherapy WHERE "antibody" = 'rituximab'

Question: What's the target for the brand mylotarg?
SQL: SELECT "target" FROM cancer_immunotherapy WHERE "brand_name" = 'mylotarg'

Question: What's the type for the brand herceptin with an approval date of before 2006?
SQL: SELECT "type" FROM cancer_immunotherapy WHERE "approval_date" < 2006 AND "brand_name" = 'herceptin'