Difference between revisions of "Kmill104 Week 8"
Jump to navigation
Jump to search
(→Results: fixing format) |
(→Results: answering more questions) |
||
| Line 4: | Line 4: | ||
==Results== | ==Results== | ||
| − | #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 | + | #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'; | ||
#What are the names of the drug products whose active ingredient (activeingred) is ATROPINE? | #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'; | ||
#In what forms and dosages can the drug product named BENADRYL be administered? | #In what forms and dosages can the drug product named BENADRYL be administered? | ||
* Form: Capsule;Oral and Strength: 50MG | * Form: Capsule;Oral and Strength: 50MG | ||
| Line 12: | Line 20: | ||
* Form: Injectable;Injection and Strength: 10MG/ML | * Form: Injectable;Injection and Strength: 10MG/ML | ||
* Form: Injectable;Injection and Strength: 50 MG/ML | * Form: Injectable;Injection and Strength: 50 MG/ML | ||
| − | + | **SELECT Form, Strength | |
| + | FROM Products | ||
| + | WHERE DrugName = 'BENADRYL'; | ||
#Which drug products have a name ending in ESTROL? | #Which drug products have a name ending in ESTROL? | ||
| − | #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.) | + | *DIETHYLSTILBESTROL, STILBESTROL |
| + | **SELECT DrugName | ||
| + | FROM Products | ||
| + | WHERE DrugName LIKE '*ESTROL'; | ||
| + | #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 | ||
#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.) | #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 | ||
#What are the names of the drug products that are sponsored (sponsor applicant column) by MERCK? | #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')); | ||
#Which sponsor applicant companies have the text LABS in their names and have products whose active ingredients (activeingred) include both ASPIRIN and CAFFEINE? | #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*'; | ||
#Also answer, would you have been able to answer these questions using the web interface that the FDA provides to this database (Drugs@FDA?) | #Also answer, would you have been able to answer these questions using the web interface that the FDA provides to this database (Drugs@FDA?) | ||
Revision as of 20:33, 13 March 2024
Purpose
Methods
Results
- 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';
- 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';
- 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';
- Which drug products have a name ending in ESTROL?
- DIETHYLSTILBESTROL, STILBESTROL
- SELECT DrugName
FROM Products WHERE DrugName LIKE '*ESTROL';
- 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
- 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
- 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'));
- 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*';
- Also answer, would you have been able to answer these questions using the web interface that the FDA provides to this database (Drugs@FDA?)
