completed queries for getting assignment information for a specific course