Difference between revisions of "Hivanson Week 8"

From LMU BioDB 2024
Jump to navigation Jump to search
(query 2)
(query 3)
Line 7: Line 7:
 
FROM Products
 
FROM Products
 
WHERE ActiveIngredient ='ATROPINE';
 
WHERE ActiveIngredient ='ATROPINE';
 +
 +
3. SELECT Form, Strength
 +
FROM Products
 +
WHERE DrugName = 'Benadryl';

Revision as of 20:26, 9 March 2024

1. SELECT DrugName FROM Products WHERE form ='INJECTABLE;INTRAVENOUS, SUBCUTANEOUS';

2. SELECT DrugName FROM Products WHERE ActiveIngredient ='ATROPINE';

3. SELECT Form, Strength FROM Products WHERE DrugName = 'Benadryl';