*Command used: <code>select * from Product where drugname = 'BENADRYL'</code>
*Command used: <code>select * from Product where drugname = 'BENADRYL'</code>
+
'''9. Which drug products have a name ''ending'' in <code>ESTROL</code>?'''
+
*DIETHYLSTILBESTROL, STILBESTROL, DIENESTROL
+
*For this question I used the tilde to signify that I was trying to compare using patterns like <code>grep</code> and <code>sed</code>. Then I was able to use <code>$</code> to indicate that I wanted only the drugs where the name had ''-estrol'' at the end. The command, therefore, was <code>select * from Product where drugname ~ 'ESTROL$';</code>
+
*Note that this search yielded 24 results but only 3 different kinds of drugs. They vary in form and dosage.