SQL Statements for Lab that could be helpful:
Copyright, MILI 2008

TO LOOK AT THE DATABASE IN WALD_RX:

select * from wald_rx

TO LOOK AT THE DATABASE IN WALD_RX WHERE YOU ARE LOOKING FOR AN AMOXICILIN WILD CARD BASED
ON THE FIRST 4 LETTERS OF THE DRUG NAME.

select * from wald_rx
  where DRUGNAME like 'amox%'


TO SUM UP THE TOTAL # OF UNIQUE PEOPLE IN THE DATABASE

select count(distinct hipaaid) 
from wald_rx

TO SUM UP THE UNIQUE NUMBER OF THE PEOPLE IN THE DATABASE TAKING AMOXICILIN 

select count(distinct hipaaid) 
from wald_rx
where DRUGNAME like 'amox%'

TO SUM UP THE TOTAL COPAY AMOUNT USED FOR AMOXICILIN

select sum(copay) as sumtot
from wald_rx
where DRUGNAME like 'amox%'