Malverso Week 6 - Revision history

Malverso: answered #13

2015-10-15T03:38:16Z

answered #13

2015-10-15T03:27:22Z

answered #12

2015-10-15T03:09:12Z

answered #11

2015-10-15T03:04:35Z

answered #10

2015-10-15T02:51:40Z

answered #9

2015-10-15T02:21:57Z

began to answer #9

@@ Line 253: / Line 253: @@
 SQL statement:
   select drugname from product,application where Product.applno = application.applno and application.sponsorapplicant = 'MERCK' group by drugname
 {{Template:Malverso}}

@@ Line 175: / Line 175: @@
 SQL statement:
   select chemical_type,count(*) from application group by chemical_type
 {{Template:Malverso}}

@@ Line 140: / Line 140: @@
 ===#10===
 *I referred to my notes to remember how to use the group by statement when counting.
 ====a.====
 *I removed the count of the Therapeutic_Potential when the value is null.
@@ Line 151: / Line 152: @@
 SQL statement:
 select therapeutic_potential,count(*) from application group by therapeutic_potential
 {{Template:Malverso}}

@@ Line 114: / Line 114: @@
 *Form and dosage are found in the Product table.
 ====a.====
-  ''Form,Dosage
+  ''Form, Dosage
   CAPSULE;ORAL, 50MG
   ELIXIR;ORAL, 12.5MG/5ML
@@ Line 137: / Line 137: @@
 SQL statement:
   select drugname from Product where drugname ~'ESTROL$'
 {{Template:Malverso}}

@@ Line 129: / Line 129: @@
 *I looked through my notes to see that we can use grep and sed commands within SQL.
 ====a.====
+Name of Drugs:
 ====b.====
 {{Template:Malverso}}