There are a number of problems you might be having. One could be that your tables are joined improperly or perhaps there is something wrong with your “Group By” line. Whenever using a function such as count or average, make sure to group by everything in your select statement except for the attribute you are performing the function on. I would recommend visiting the TA lab for more specific help.