Kmill104 Week 8

Results

1. What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS?
   • LOVENOX, VELCADE, APIDRA, ENOXOPARIN SODIUM, ACTEMRA, BORTEZOMIB, WEZLANA
     • SELECT DrugName FROM Products WHERE form ='INJECTABLE;INTRAVENOUS, SUBCUTANEOUS';
2. What are the names of the drug products whose active ingredient (activeingred) is ATROPINE?
   • ATROPEN, ATROPINE, ATROPINE (AUTOINJECTOR)
     • SELECT DrugName FROM Products WHERE ActiveIngredient ='ATROPINE';
3. In what forms and dosages can the drug product named BENADRYL be administered?
   • Form: Capsule;Oral and Strength: 50MG
   • Form: Elixir;Oral and Strength: 12.5MG/5ML
   • Form: Capsule;Oral and Strength: 25 MG
   • Form: Injectable;Injection and Strength: 10MG/ML
   • Form: Injectable;Injection and Strength: 50 MG/ML
     • SELECT Form, Strength FROM Products WHERE DrugName = 'BENADRYL';
4. Which drug products have a name ending in ESTROL?
   • DIETHYLSTILBESTROL, STILBESTROL
     • SELECT DrugName FROM Products WHERE DrugName LIKE '*ESTROL';
5. Produce a table listing all of the known values for the therapeutic_potential column in the application table and how many application records there are of each. (Side note: The therapeutic_potential codes are explained in the ReviewClass_Lookup.txt file, in case you’re interested.)
   • Not possible, no therapeutic_potential column
6. Produce a table listing all of the known values for the chemical_type column in the application table and how many application records there are of each. (Side note: The chemical_type codes are explained in the ChemTypeLookup.txt file, in case you’re interested.)
   • Not possible, no chemical_type column
7. What are the names of the drug products that are sponsored (sponsor applicant column) by MERCK?
   • • SELECT Products.DrugName FROM Products LEFT JOIN Applications ON Products.ApplNo = Applications.ApplNo WHERE (((Applications.[SponsorName])='MERCK'));
8. Which sponsor applicant companies have the text LABS in their names and have products whose active ingredients (activeingred) include both ASPIRIN and CAFFEINE?
   • Watson Labs, Nostrum Labs Inc, Dr Reddys Labs SA
     • SELECT SponsorName, ActiveIngredient FROM Applications RIGHT JOIN Products ON Applications.ApplNo = Products.ApplNo WHERE ActiveIngredient LIKE '*ASPIRIN*CAFFEINE*' AND SponsorName LIKE '*LABS*';
9. Also answer, would you have been able to answer these questions using the web interface that the FDA provides to this database (Drugs@FDA?)