Table: marine_drug_data
Columns: clinical_status
compound_name
trademark
marine_organism
chemical_class
molecular_target
clinical_trials
disease_area

Question: What is the molecular target listed under the compounded name of hemiasterlin (e7974)
SQL: SELECT "molecular_target" FROM marine_drug_data WHERE "compound_name" = 'Hemiasterlin (E7974)'

Question: What is the molecular target listed under the trademark of irvalec ®
SQL: SELECT "molecular_target" FROM marine_drug_data WHERE "trademark" = 'Irvalec ®'

Question: What is the compound name listed where marine organism α is worm
SQL: SELECT "compound_name" FROM marine_drug_data WHERE "marine_organism" = 'Worm'

Question: How many compound names list a chemical class of depsipeptide and a clinical trials β value of 1/7?
SQL: SELECT COUNT("compound_name") FROM marine_drug_data WHERE "chemical_class" = 'Depsipeptide' AND "clinical_trials" = '1/7'

Question: What is the trademark listed for the molecular target : dna-binding?
SQL: SELECT "trademark" FROM marine_drug_data WHERE "molecular_target" = 'DNA-Binding'

Question: How many trademarks list a molecular target of minor groove of dna and a clinical status value of phase i?
SQL: SELECT COUNT("trademark") FROM marine_drug_data WHERE "molecular_target" = 'Minor Groove of DNA' AND "clinical_status" = 'Phase I'