committing the queries

still need clarification on queries 2 and 3