queries 1-9 work, had to update create and insert b/c of pay_rate data type change.