added comments
updated queries to include full table names