Difference between revisions of "Kmill104 Week 8"

From LMU BioDB 2024
Jump to navigation Jump to search
(→‎Results: answering more questions)
(→‎Results: fixing formatting)
Line 5: Line 5:
 
==Results==
 
==Results==
 
#What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS?
 
#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
+
#*LOVENOX, VELCADE, APIDRA, ENOXOPARIN SODIUM, ACTEMRA, BORTEZOMIB, WEZLANA
−
**SELECT DrugName
+
#**SELECT DrugName FROM Products WHERE form ='INJECTABLE;INTRAVENOUS, SUBCUTANEOUS';
−
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)
+
#*ATROPEN, ATROPINE, ATROPINE (AUTOINJECTOR)
−
**SELECT DrugName
+
#**SELECT DrugName FROM Products WHERE ActiveIngredient ='ATROPINE';
−
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
−
* Form: Elixir;Oral and Strength: 12.5MG/5ML
+
#* Form: Elixir;Oral and Strength: 12.5MG/5ML
−
* Form: Capsule;Oral and Strength: 25 MG
+
#* Form: Capsule;Oral and Strength: 25 MG
−
* 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
+
#**SELECT Form, Strength FROM Products WHERE DrugName = 'BENADRYL';
−
FROM Products
 
−
WHERE DrugName = 'BENADRYL';
 
 
#Which drug products have a name ending in ESTROL?
 
#Which drug products have a name ending in ESTROL?
−
*DIETHYLSTILBESTROL, STILBESTROL
+
#*DIETHYLSTILBESTROL, STILBESTROL
−
**SELECT DrugName
+
#**SELECT DrugName FROM Products WHERE DrugName LIKE '*ESTROL';
−
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.)  
 
#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
+
#*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
+
#*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
+
#**SELECT Products.DrugName FROM Products LEFT JOIN Applications ON Products.ApplNo = Applications.ApplNo WHERE (((Applications.[SponsorName])='MERCK'));
−
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
+
#*Watson Labs, Nostrum Labs Inc, Dr Reddys Labs SA
−
**SELECT SponsorName, ActiveIngredient  
+
#**SELECT SponsorName, ActiveIngredient FROM Applications RIGHT JOIN Products ON Applications.ApplNo = Products.ApplNo WHERE ActiveIngredient LIKE '*ASPIRIN*CAFFEINE*' AND SponsorName LIKE '*LABS*';
−
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:37, 13 March 2024

Purpose

Methods

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?)
Retrieved from "https://xmlpipedb.lmucs.org/biodb/spring2024/index.php?title=Kmill104_Week_8&oldid=2085"